ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multi Pages Setup (https://www.excelbanter.com/excel-programming/420715-multi-pages-setup.html)

maperalia

Multi Pages Setup
 
I wonder if you can help with this form.
I created a multipages form with "Page1" and "Page2". Each one has labels
with boxes and "OK" bottom (see code below). I do not know how to set the
code for the object and the statement in my module.
Could you please tell me how to do it.
Thanks in advance.
Maperalia



'########## Form Code #########
Public Vertical_Line As Double
Public Horizontal_Line As Double
Public Distance As Double
Public Angle As Double

Private Sub bOK_Click()
'Make sure the user is entering numbers and not text
If IsNumeric(txtDistance.Text) And IsNumeric(txtAngle.Text) Then
Distance = txtDistance.Text
Angle = txtAngle.Text
Hide
Else
MsgBox "You must enter numeric values for all fields"
End If
End Sub
'###########################################

'#### Start User form located in my Module ##############
Dim newForm As New frmRevolve
newForm.Caption = "Enter Values in Inches"
newForm.Show
RevolveDistance = newForm.Distance / 39.37008
RevolveAngle = newForm.Angle / 57.29577951 'Converting From Radians to Degrees
Set newForm = Nothing
'#### End User form located in my Module ###############


All times are GMT +1. The time now is 02:50 PM.

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