option button and userform question

[Guest]

Is there a default property setting for an option button that will allow any
key stroke to select the the option (optionbutton.value = true)?

Also, this is in another post but I will take an answer here. What is wrong
with the following?

..cmbxPhonePre.Value = Mid(WSSCal.Range("Phone_Number").Value, 4, 3)

 

[meh2030]

Is there a default property setting for an option button that will allow any
key stroke to select the the option (optionbutton.value = true)?

Also, this is in another post but I will take an answer here. What is wrong
with the following?

.cmbxPhonePre.Value = Mid(WSSCal.Range("Phone_Number").Value, 4, 3)

Shawn,

I'm not sure about finding a way for "any" key stroke to select an
option, but the space bar will select options.

As for the Mid Function, make sure that the WSSCal is an object and
the "." before cmbxPhonePre inferrs that you have the syntax within a
With...End With statement.

I hope this helps.

Matt