ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   multipage userform question (https://www.excelbanter.com/excel-programming/343777-multipage-userform-question.html)

JT

multipage userform question
 
I have a multipage userform. One of the pages will be used for data entry.

On the main part of the form, I have 2 buttons (Enter & Quit). I would like
to disable thees buttons when I'm on the data entry page but am having
trouble getting started. Any help would be appreciated. Thanks.
--
JT

Dave Peterson

multipage userform question
 
I used the 3rd page as my data entry page:

Option Explicit
Private Sub MultiPage1_Change()
Me.CommandButton1.Enabled = Not CBool(Me.MultiPage1.Value = 2)
Me.CommandButton2.Enabled = Not CBool(Me.MultiPage1.Value = 2)
End Sub



JT wrote:

I have a multipage userform. One of the pages will be used for data entry.

On the main part of the form, I have 2 buttons (Enter & Quit). I would like
to disable thees buttons when I'm on the data entry page but am having
trouble getting started. Any help would be appreciated. Thanks.
--
JT


--

Dave Peterson


All times are GMT +1. The time now is 03:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com