Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default 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 ###############
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing multi-pages yclhk Excel Discussion (Misc queries) 1 November 9th 09 04:50 PM
Multi tab setup pgarcia Excel Discussion (Misc queries) 1 May 20th 09 06:20 PM
printing multi pages on one sheet Ms. J Setting up and Configuration of Excel 1 April 26th 07 03:56 AM
how to setup all pages at the same time? dora Setting up and Configuration of Excel 1 September 13th 05 11:37 PM
Page setup for multiple pages Lynn[_5_] Excel Programming 1 October 21st 03 05:28 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"