Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Worksheet Range in a Textbox
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Worksheet Range in a Textbox
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 "roadkill" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Dynamic Range | Excel Worksheet Functions | |||
Unprotect a textbox in a protected worksheet | Excel Discussion (Misc queries) | |||
Only display a specific range | Excel Discussion (Misc queries) | |||
I have had trouble with textbox text to worksheet | Excel Discussion (Misc queries) | |||
Display row numbers of a range | Excel Worksheet Functions |