- 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
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