Display Worksheet Range in a Textbox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to display a range of data from a Worksheet on a user form. From what
I read in "help", it sounds like a textbox should be able to do this. But
I've tried a few things (e.g. unsuccessfully tried to set ControlSource to
the range that I want) and can't seem to make it work.

How do I display a range of cells (or even Worksheet, if that's the only
option) on a user form?

Thanks,
Will
 
Will,

Used a listbox on your userform, and use code like

Private Sub UserForm_Initialize()
Me.ListBox1.List = Range("NameORAddressOfRange").Value
End Sub

Set the column count of the listbox to the number of columns that are in your range that you want to
show.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Calculation not working????????????? 3
Code to format cells on several worksheets 2
Setting Scope of name ranges to particular worksheet 2
Lookup value, display multiple values in new worksheet 4
AVERAGE cells on another worksheet when the range is calculated 1
Linking multiple ranges and worksheets to MS Word 1
Restrictions on worksheet display 3

Back
Top