VB Form as Menu

J

JAD

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
 
B

Bob Phillips

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
VBA Help with Form 1
form buttons on sheet collapse on unhide - sometimes 5
Using Form Buttons / Objects 2
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
Survey Form as a Project 1
Adding a button to a VB form 1
Clearing Fields in a Word Form 5

Top