I'd use a public variable in a General module and just plop the value into it.

Then any routine--including the userform_initialize event can pick it up and do
anything it wants with it.

Just a comment...

The "on change" event is pretty old. You may want to consider using a
worksheet_change event instead. You may find it easier to use and nicer to
control.

Dave O wrote:

I have some On Change event code that triggers when a change is made
to a certain cell: the code performs VLOOKUPs and assigns the results
of the lookups to variables- call them V1, V2, V3.

The same event code opens a userform. I'd like to show the values of
V1, V2, and V3 as captions in Labels, and have the user click a radio
button to indicate his choice.

I've got this about together, but I need a hint: how do I use a
variable from the On Change event code in the user form? Is this a
matter of declaring a public variable?

Thanks

--

Dave Peterson