Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 ############### |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Printing multi-pages | Excel Discussion (Misc queries) | |||
Multi tab setup | Excel Discussion (Misc queries) | |||
printing multi pages on one sheet | Setting up and Configuration of Excel | |||
how to setup all pages at the same time? | Setting up and Configuration of Excel | |||
Page setup for multiple pages | Excel Programming |