option button and userform question
 

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)



--
Thanks
Shawn

option button and userform question
 

On Jun 28, 4:14 pm, Shawn wrote:
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)

--
Thanks
Shawn

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