Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Form as Menu
I have designed a VB Form on which I have placed Option Buttons as the
objects the user would click on to move to another location in the workbook. 1st Question: How do I activate the form to pop up at any location by the end user? 2nd Question: How do I activate the macros through the Option Buttons? 3rd Question: Does anyone have a recommendation of a book that stricly addresses the use and programming of VB Forms? Any help would ba appreciated. Thank You, JAD |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Form as Menu
1. I presume that you mean VBA not VB
Userform1.Show 2. You trap the buttons click event Private Sun OptionButton1_Click() 'do something End Sub -- __________________________________ HTH Bob "JAD" wrote in message ... I have designed a VB Form on which I have placed Option Buttons as the objects the user would click on to move to another location in the workbook. 1st Question: How do I activate the form to pop up at any location by the end user? 2nd Question: How do I activate the macros through the Option Buttons? 3rd Question: Does anyone have a recommendation of a book that stricly addresses the use and programming of VB Forms? Any help would ba appreciated. Thank You, JAD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print user form and add menu bar to the form | Excel Programming | |||
How to add Menu Bar to User form | Excel Programming | |||
Help using form as menu | Excel Programming | |||
Menu attached to a form? | Excel Programming | |||
Add Menu to a VBA Form | Excel Programming |