Display Data in a userform (textbox)

[mrjayps]

Hi - I have a userform and am displaying data from Worksheet "Price_List" Cell G12. I am able to display it by entering Price_List!G12 into control source, however once the userform is activated, the value overides the formula in my spreadsheet. How am I able to simply display the data, and retain the formula in the spreadsheet.

If variables on the userform/spreadsheet change, I require the data display on the userform to change too.

Many thanks

 

[My Aswer Is This]

Textboxes are not designed to handle large ranges of data.
A multicolumn listbox could do this.
What do you want to do with the information after putting it in the textbox even if you could do this.

Do you just want to see the data or modify the data?

 

[kirgan]

Textboxes are not designed to handle large ranges of data.
A multicolumn listbox could do this.
What do you want to do with the information after putting it in the textbox even if you could do this.

Do you just want to see the data or modify the data?

i just want to see the data, like a big window displaying all the data. if the textbox i mentioned is not the best option. i wld be glad with your recommendation. am not good at VBA for excel. so i really need assistance.

 

[igold]

You posting title says:Display Data in a userform (textbox)

But then you say:
I need help generating a pop up window(table)

Which is it a UserForm Textbox?
Or a Sheet(Table)

And it would be impossible to put all the data from Cells (A1:X30) all into one UserForm Texbox and be readable.

Probably because you are not responding to the OP, but rather someone who tacked a question on afterwards...

 

[My Aswer Is This]

You say your not good with Vba.
Do you know how to build and operate a UserForm?
Doing this is Vba.
How about seeing all this data in a new sheet

Seeing all the data From Range("A1:X30") Can be put in a textbox if you want to see one cell below the other like:

Joe
Mike
Jane
Carl
Susan
Amos
etc.
etc.

If you know how to build a UserForm a multicolumn listbox would be better. But you cannot modify values in a listbox.

 

[My Aswer Is This]

If you Know how to build and use a Userform.
Put a wide Listbox on your UserForm and use this code in your form

Private Sub UserForm_Initialize()
ListBox1.ColumnCount = 24
ListBox1.RowSource = "A1:X30"
ListBox1.ColumnHeads = True
End Sub

 

[kirgan]

If you Know how to build and use a Userform.
Put a wide Listbox on your UserForm and use this code in your form

Private Sub UserForm_Initialize()
ListBox1.ColumnCount = 24
ListBox1.RowSource = "A1:X30"
ListBox1.ColumnHeads = True
End Sub

Thanks bros i'd try it and revert asap.
Thanks alot

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Thanks bros i'd try it and revert asap.
Thanks alot