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

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