Create an Excel UserForm Part 1 of 3

[ATPK51]

Thank you very much. it's very helpful. from Vietnam

[sabilabry]

hi! can i ask how if i want the date below appear automatically like im putting a barcode on the first line then succeeding line will have its data match on the database... ??

[epilef759]

I fall in love with your voice, I love it. Thank you for the info, good info, great voice!

[MJDiDaC]

You can also make a form using the spreadsheet and take advantage of the following:

1. The user being at ease with UI (user interface).

2. Capability to populate the data by formula or reference to an existing Excel data.

3. Capability for multi-row data (like a Purchase Order)

4. Ability for inter-field data dependencies (even inter-row) and calculations

[contextures]

@MJDiDaC Thanks for the suggestion about worksheet data entry forms. There are instructions for one on my website

[adnanBahrani]

good lesson :)

but i think if the 3 lessons integrated into one lesson would be better.

:)

thanks again

[contextures]

@fraserdes Set the ScrollHeight property to the full height of the user form, when sized to show everything. For example, you might have to set it to 300 to see all the controls, if there were no scroll bar. Then, you can reduce the height of the user form, and the scroll bar will show everything in the ScrollHeight range.

[fraserdes]

Hi I have created a UserForm similar to yours, but alot longer. The problem I have is that since my form is longer I need a scroll bar, so I added one it through the properties area in the design view but for some reason the scroll button wont work! could you please help me

[rimalnigam]

Your voice and the lesson both are great.

[contextures]

@rimalnigam Thanks! I'm glad you liked the video.

[contextures]

jigmandude, you're welcome, and thanks for letting me know that the video helped you.

[jigmandude]

thank you for poasting this! It helped me create my first user form :)