Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to call a user form?
Hey guys, I have a user form and I would really like it to be able to be opened from a button I can put on the toolbar like you can with macros. Is there an easy way to do this? Thanks H -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=401208 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to call a user form?
Good afternoon HRU48 The macro need only be as simple as this: Sub CallForm() Userform1.Show End Sub To call it from a button follow these steps: Right click on a toolbar and select customize. From the commands tab drag an icon (any icon) onto the toolbar you want to add it to. Then right click your new icon, give it a name, give it a trendy image (or draw your own) and assign your macro. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=401208 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to call a user form?
thanks, your a star.. i knew it was something really obvious but its been a long day :) -- Hru48 ------------------------------------------------------------------------ Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895 View this thread: http://www.excelforum.com/showthread...hreadid=401208 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button to call a user form?
Hi Hru48 No problem. Thanks for the feedback. DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=401208 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User form and Command button | Excel Discussion (Misc queries) | |||
use a button to open a user form? | Excel Discussion (Misc queries) | |||
User Form Spin Button | Excel Programming | |||
A "previous" button on a user form | Excel Discussion (Misc queries) | |||
User Form Button Code | Excel Programming |