![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Mar 2002
Location: Weathersfield,VT
Posts: 18
|
Must be dementia creeping up on me, but I cannot remember how to do a tiny 2 or 3 step macro for a button on a worksheet to open a data form for info entry for that worksheet. When creating the macro and getting the form for data layout of that sheet, working those steps, I can't close the form and then go to tools and stop the macro recording and have the macro run. Can someone please tell me what foolish step I'm missing? Thanks in advance. Bob
|
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Jefferson City, Missouri
Posts: 383
|
just add userform1.show to your command button click event. this will bring up your user form for data. if you have a cancel button on your user form add unload userform1 to its click event. if you have a button on your form that posts your data to the worksheet then add unload userform1 to the end of the macro.
HTH
__________________
I appreciate the help from everyone at Mr. Excel. viper |
|
|
|
|
|
#3 |
|
Board Regular
Join Date: Feb 2002
Location: Huntington Beach, CA USA
Posts: 327
|
Private Sub CommandButton_Click()
UserForm1.Show End Sub Private Sub CommandButton2_Click() UserForm1.Hide End Sub James |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|