Multipage Control in UserForm

[andytpl]

Hi there,

I have created a multipage userform in a worksheet. Actually only 2 pages. I want to provide some form of control which page is displayed depending on the location of the cursor. In my case I want to display Page 1 if the cursor is anywhere in Column B from row 20 onwards and Page 2 if the cursor is anywhere in Column D from row 20 onwards. I have read somewhere on the Web how this can be done but I am not well verse enough to get it done. I hope some help from this forum. Thx.

[Bob Phillips]

Just use

[vba]

MultiPage1.Value = 0
[/vba]

for page 1, etc.

[andytpl]

I don't quite understand how to incorporate your suggestion into the set of codes I am using right now. Please help.

If Activecell.Row > 20 AND Activecell.Column = 2 Then

Userform1.Show

Elseif Activecell.Row > 20 AND Activecell.Column = 4 Then

Userform1.Show

Else

Msgbox "Please Select Appropriate Cells"

End If

[Bob Phillips]

Un tested

[vba]

If Activecell.Row > 20 AND Activecell.Column = 2 Then

With Userform1

.Multipage1.Value = 0
.Show
End With

Elseif Activecell.Row > 20 AND Activecell.Column = 4 Then

With Userform1

.Multipage1.Value = 1
.Show
End With

Else

Msgbox "Please Select Appropriate Cells"

End If
[/vba]

[andytpl]

Thank you very much. You are a life saver.