Macro opening form after drop down field selection

**aCmE** · 01-04-2011, 07:30 AM

Hi,

I'm new here aswell as in matter of forms and macros in MS Office so please be tolerant :P.

I would like to create drop down form field consisted of a few positions. Picking any certain position should make another form appear.

For example you pick some certain type of device from drop down list and u want tick boxes with options to appear, another position another form and so on. I thought about recording macros for every position and assigning them.

Maybe it could also be made by option buttons or checkbox.

Thanks for any guidance and suggestions.

**jwright650** · 01-04-2011, 07:57 AM

Can you post an example of what you are working with?

If you edit your post and click "Go Advanced", you will see "manage attachments" and a place where you can upload your xls file or a sample xls file.

**aCmE** · 01-04-2011, 10:00 AM

I'm working with word. I haven't got any certain files prepared yet. My basic idea is to create few forms in word, store them or hide them, and then by selecting from drop down form field making certain form appear in the same document

I've found some simple script :

Private Sub Command1_Click()
    If CBool(Check1.Value) Then
        Load Form2
        Form2.Show
    End If
End Sub

It is for checkbox. But thats basically what i want to achieve. I'm looking for some already known solutions, scripts.

**jwright650** · 01-04-2011, 10:05 AM

I apologize for not noticing that you were woking with Word. I had hit the "New Posts" button and wasn't watching the forum where your thread was located.

**aCmE** · 01-04-2011, 10:30 AM

No problem. If you had any idea i would be thankful.

**jwright650** · 01-04-2011, 10:41 AM

I'm still very new at using VBA, and even newer at using Word, however I don't mind trying to help.
I have noticed that there are some differences in Excel and Word as to how some things work. In Excel there are several ways to assign a macro to an object or text box to show a userform, but it doesn't seem as straightforward in Word.