Thanks Dave,
if I wanted to refer to a specific cell that I named would the syntax be
ws.range ("rangename')
or
ws.cells ("rangename")
or
ws.cells (a:2)

"Dave Peterson" wrote:

Debra Dalgleish has a sample userform at:
http://www.contextures.com/xlUserForm01.html

That has code that writes to a worksheet.

TimT wrote:

I have a userform that collects information that needs to be referenced later
on in a procedure.
How would I reference the value of an option button or listbox, combobox
etc. in a formula/ if statement?
Any takers?

--

Dave Peterson