Macro with user form to fill in Information

I have tried to make a form using the view code button and have failed miserably. I am attaching the file with the information needed if someone could please help.

Hi,

Hopefully this example will get you started. If you have trouble making the rest of the text boxes or adding further features, let me know. I'm not an form expert, but there are a lot of pros here who can jump in at any time.

Good luck.

abousetta

Hi,

I took the UserInfo.Show and put it in a Module, instead of having it as an event behind the workbook. Now click on the button and see what happens.

I like MarvinP's insidious placing of the userform call button. Also I made some minor modifications like using an array to pass the values (makes for less typing) and corrected the TabIndex order. Finally I added some comments describing what everything is just in case anyone reads the code who is not familiar with vba.

If you interested in something more advanced (e.g. database features), I know that J-walk and RoyUK have some nice turnkey solutions you can apply.

Hope this helps.

abousetta

Thanks to all who have help me with this. I need some more help if possible. I am attaching the file again. I would like to add a drop down to choose from. under membership, how can I do a drop down box with the following: Full, Retired, Honorary, Student, Affiliate. Under the phone numbers I would like to set them up to be consistent with phone numbers.

Thanks

Hi,

OK. Regarding the membership type, there are two possibilities I can think of easily. I have put both of them for you in the excel sheet.

Option #1: Create a combobox in the userform and results populated in Column N

Option #2: Create a dropdown menu (Data --> Validation --> List) on the excel sheet itself that you can choose from after the userform is closed (Column O).

Your choice.


As for your second question regarding numbers, you will need to be a little more detailed in your request. For example, do you want several text boxes on the userform and then the phone number is populated in the excel sheet or how do you envision the final result?

Hope this helps.

abousetta

Hi,

If you are satisfied with the answers, then please mark the thread as Solved.

Good luck.

abousetta