I have a Custom form Options Popup appear whenever an "Options" Comman
button is pressed on my main page. Now within this Popup there ar
several options that the user will be able to manipulate. Although
can't get the values to pass back from the popup.

On the main page there is a "Calculate" button that does all th
calculations, that leads to a Private Sub that does all the work. S
basically Im asking can I get a custom form options to work with m
spreadsheet

here is some code, I hope it helps

Private Sub cmdOpts_Click()
Load SSheduleOpt 'Load the Form into memory
SSheduleOpt.Show 'Show the form on screen
End Sub

This is where the popup appears although it does appear but it does no
affect my spreadsheet yet.

Private Sub cmdCalcWD_Click()
Dim SSheet As New SSched

' create an instance of your class object
'Set SSheet = New SSched

'Functions to actually work the Spreadsheet
cmdClear_Click 'Clears the workspace
SetDays SSheet 'Sends SShet Variable to the SetDays Su
Routine
End Sub
This one is the Calculate button, don't mind the custom class, but
just want to know how to tie my options menu into "SetDays" Sub. M
brain is kinda scattered (Long Day of coding) so if it doesn't mak
sense let me know I'll Edit it.

Thanks in advance

--
Xiaze
-----------------------------------------------------------------------
Xiazer's Profile: http://www.excelforum.com/member.php...fo&userid=3158
View this thread: http://www.excelforum.com/showthread.php?threadid=54217