ExcelBanter - UserForm to A Range

David, Go to Google www.google.com and use the Groups option, and the
Advanced Search, and then
you can search fro any messages with your name. You will see them all then.

--

HTH

Bob Phillips

"Dan Gesshel" wrote in message
. ..
I bet I did. Problem is I can't see them. For some reason my e-mail was on
the fritz and even though I sent it, I couldn't see the post or the
responses. If you can forward me anything I would greatly appreciate it
William.

Thanks

"William" wrote in message
...
Hi Dan

You received a couple of good replies when you posted the same question
a
couple of days ago.

--
XL2002
Regards

William

"Dan Gesshel" wrote in message
. ..
| Hello.
|
| I am trying to take a value from a UserForm Combo box and place it
into
a
| range. The UserForm may be chosen many times, so I need a procedure
that
| places the value in the next empty space below the previous value on a
| worksheet.
|
| Getting the value into the range isn't a problem. It's getting to step
to
| the next cell that seems to be causing me grief.
| Here's what I have so far:
|
| 'Place Value in first cell
| If Sheets("Data").Cells(Row????, 144).Value = "" Then
| Sheets("Data").Cells(Row????, 144).Value = SKU.Value
|
| Else
|
| 'If first cell is full, move down to next cell.
| If Sheets("Data").Cells(Row????, 144).Value < "" Then
| Sheets("Data").Cells(Row???, 144).Value = SKU.Value
| End If
| End If
|
| I need to know how to define the Row variable so it will work. (Or
perhaps
| some kind of Loop or For Next Statement would be better.... don't
know.)
Am
| I making any sense?
|
| I do not want to use the ActiveCell Property at all, since this sheet
will
| not be active. (I also can do this procedure with ActiveCell without a
| problem.)
|
| Can anyone help? I'd appreciate it.
|
| Thanks.
|
| Dan
|
|