Excel Wksheet Using Visual Basic
-
Hey Everyone! I'm a rookie at this stuff so I'm seeking help. I've built buttons and huge macros in my excel spreadsheets and I know how to assign buttons to my macros. Here is where I'm stuck. I just learned how to build userforms with textboxes, buttons, and macros to activate userform. I just can't figure out how to open my userforms in my worksheet without going into the visual basic editor. I would like to learn how to program a button to open my userform in my worksheet. Can anyone please help me. If possible I would like to see a sample of codes. Thank you so much..... :confused:
-
Hey Everyone! I'm a rookie at this stuff so I'm seeking help. I've built buttons and huge macros in my excel spreadsheets and I know how to assign buttons to my macros. Here is where I'm stuck. I just learned how to build userforms with textboxes, buttons, and macros to activate userform. I just can't figure out how to open my userforms in my worksheet without going into the visual basic editor. I would like to learn how to program a button to open my userform in my worksheet. Can anyone please help me. If possible I would like to see a sample of codes. Thank you so much..... :confused:
I can't remember exactly, but in the code you have for a button you can do something like:
MyUserForm.Show()
to launch your form... I think! :~ RageInTheMachine9532
-
I can't remember exactly, but in the code you have for a button you can do something like:
MyUserForm.Show()
to launch your form... I think! :~ RageInTheMachine9532
-
TO: RageInTheMachine9532 Thank you so much for your input. It worked. Now I can continue on with my project for work.:laugh:
No problem! Thanks! RageInTheMachine9532