Excel VBA option button question

[CindyG]

I have designed a userform in excel VBA 6 which includes some optio
buttons, to input data into a spreadsheet.

I have also designed another userform to retrieve previously submitte
information from the spreadsheet, for modification purposes.

My problem is: I cannot get the form to load the previously submitte
option button value. I have searched high and low for an answer with n
results.

It should also be noted that I have very little idea what I'm doing
am teaching myself VBA from internet sites.

Any assistance would be appreciated.

Cind

 

[Chip Pearson]

Where are you storing the previously stored information. When you
unload a form, all the values of its controls are lost and revert
to their default values.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"CindyG" <[email protected]>
wrote in message
news:[email protected]...

 

[CindyG]

Hullo, Chip:

The values from the initial userform are stored onto a spreadsheet.

The user then launches a new userform (Modify Data) which retrieves the
previously submitted data via a search button. All values are returned
correctly except for the values previously submitted via option
buttons.

CindyG