Excel VBA Multipage


Joined
Nov 4, 2010
Messages
1
Reaction score
0
I created a macro within Excel 2007 for a userform. There are two problems:

1. The tabs to switch to pages have to be double clicked in order for the page requested to be on top.

2. The userform includes comboboxes. The first page comboboxes does not appear until you click on page 2 and everytime I click on a page after that it continues to loop the information in the combo boxes so instead of having yes or no, I now have yes, no,yes,no...

Here is a sample of the code:

Private Sub MultiPage1_change()
UserForm1.MultiPage1.Value = 0
Dim c2ans As Range
Dim c3ans As Range
Dim c4ans As Range
Dim cOth As Range
Dim ws As Worksheet
Set ws = Worksheets("LookupLists")
Me.MultiPage1.Value = 0
For Each c3ans In ws.Range("_3answers")
With Me.cmb1a
.AddItem c3ans.Value
End With
Next c3ans
Me.MultiPage1.Value = 1


End Sub
 
Ad

Advertisements


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

Top