Listing the value of a spinbutton...

bahllr

Board Regular
Joined
May 7, 2009
Messages
62
I have a userform (VBA) with a spinbutton and an accompanying textbox. I want to list text in a column for the number in the text box. If I click the spin button three times and have the value 3 in the textbox, is there a way that I can have "Location 1", "Location 2" and "Location 3" in 3 rows in the same column?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,099,079
Messages
5,466,492
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top