Pop-up menu Macro that fills cells

**alin_m** · 06-06-2010, 04:33 PM

Hello everybody,

Please help me with this problem.
I need to create a macro that enables a pop-up menu (after a button is pressed), which contains blank fields, drop down lists and check-boxes; so, after the user completes these fields in the menu, and submits it, rows will be inserted with filled cells (depending of data inserted in the fields of the menu) containing that information.

I don't want to go into details, I just want to know how to start. I worked with macros before, but I don't know how to create the menu with the those fields.

Thank you and best regards.

**phil_b** · 06-06-2010, 04:56 PM

you need to look at creating a userforms in VBA (same area as the modules). If you call it frmMain you then would have something like this:

Please Login or Register  to view this content.

now the above will load and show your form on the user interface with any controls you have added after you click the button in Excel. To setup these controls/ any data etc you need to add an _Initialize event in the form as follows:

Please Login or Register  to view this content.

**royUK** · 06-07-2010, 01:20 AM

See the example http://www.excelforum.com/excel-prog...ml#post2319735here for "pooping up the form. Then look at the DatabaseForm for adding data to rows

http://excel-it.com/vba_examples.htm

**alin_m** · 06-08-2010, 05:44 AM

Thank you very much !
That's all I need to know in order to get started with this.

**royUK** · 06-08-2010, 01:36 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save