Embed your databoxes on the form then address them through form.property
setups like
Range.("A1").Value = Form1.Textbox1.text
or constructs in that vein -- ;-)


--
Wendell A. Clark, BS
-------------------------------------

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may
contain confidential and privileged information for the use of the
designated recipients named above. If you are not the intended recipient,
please notify us by reply e-mail. You are hereby notified that you have
received this communication in error and that any review, disclosure,
dissemination, distribution or copying of it or its contents is prohibited.
If you have received this communication in error, please destroy all copies
of this communication and any attachments. Contact the sender if it
continues.


"Xiazer" wrote in
message ...

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

On the main page there is a "Calculate" button that does all the
calculations, that leads to a Private Sub that does all the work. So
basically Im asking can I get a custom form options to work with my
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 not
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 Sub
Routine
End Sub
This one is the Calculate button, don't mind the custom class, but i
just want to know how to tie my options menu into "SetDays" Sub. My
brain is kinda scattered (Long Day of coding) so if it doesn't make
sense let me know I'll Edit it.

Thanks in advance.


--
Xiazer
------------------------------------------------------------------------
Xiazer's Profile:
http://www.excelforum.com/member.php...o&userid=31581
View this thread: http://www.excelforum.com/showthread...hreadid=542174