"Pete" wrote in message
...
I'm using textboxes within a UserForm and have not written any code for
that
part yet. It also has action buttons # 1 to 4 for the test. I'll be the
only user. So I guess I need to write some code rather than just work
with
the textbox properties?
That's always my advice. I hate those properties. And if you don't use
them, you could use a label instead of a textbox, although you may want a
textbox for appearance sake. Name those ranges and your Userform_Initialize
event will look like
Me.tbxFirst.Text = Sheet1.Range("Choice1").Value
Me.tbxSecond.Text = Sheet1.Range("Choice2").Value
etc..
--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com