Ivan: Thanks for all the help...Could you look at this?

Posted by Cory on July 03, 2001 6:39 AM

Ivan:
For the first one I understand using option explicit as a tool to trap and pinpoint errors, but I can't find the misspelling of the declaration that lets it fall through to vbNo.

As for the second one, I was trying to capture what the user selected with the combobox and place that selection in the cell sheet4.range("b3"). Since then I've figured out that I don't need the ".text", and I've also noticed instead of using the sheet.range syntax (which gives me an error), I have to activate the desired sheet first then just refer to it's cell:

sheet4.activate
range("b3") = combobox1.value

My problem was excel wasn't accepting the "Format" code which was trying to make what was selected in the combobox display as a time, ie: 8:00 AM instead of : 0.8333333333334

I appreciate the help, Ivan.
Cory

Posted by Cory on July 03, 2001 8:05 AM

Or anyone... It doesn't have to be Ivan...

Posted by Ben O. on July 03, 2001 8:27 AM

Cory,

Just a few suggestions. I don't know how to make time values in combo boxes appear as time values. You might want to consider using a ListBox. I had the same issue a while ago, and I ended up using listboxes.

You also might not have to activate that sheet in order to enter that text in B3. Try using this syntax: Sheets(Sheet4).Range("B3") or Sheets("Sheet Name").Range("B3").

-Ben

Ivan:

Posted by Cory on July 03, 2001 2:46 PM

Thanks Ben!

You solved my problem of the sheet references! I can get the combobox to show the time value as long as it's Style property is set to :

0- frmStyleDropDownCombo

But that doesn't prevent the user from entering their own value in the text portion of the cbo

Thanks anyway! Some more digging will do...