Userform Textbox and Label change from cell

Hi,

I want a floating userform (showmodel = false) to display the results of a cell.

On excell spreadsheet I can assign a cell value to an object/shape, as the cell value changes so does the display on the object automatically.

I want the same results on a userform.

I tried the texbox & using the the controlsource from the properties window, this was only good for one result. for the next result the textbox won't change its value.

As i want this for display purpose only can i use the label for the above problem

I am new at VBA, so please bare with me.

This is what I am doing:
1) I click the userform button to open the userform
2) I use the autofilter to filter numbers, and all works fine, numbers change on cell and userform textbox.
3) I press X on the userform to close
4) I press the userform button to bring the Userform back to the screen
5) Now when I use the autofilter the Textbox numbers do not change. A3 also does not change.

Thats the problem I am having, it seems like the userform disables my equation on A3 (thats the reason its not on A2, others the whole subtotal equation gets deleted and replaced with the actual number)

Is it something that i am doing wrong or have i not set things properly.

Please help (even if i am a total novice!!!)

Thanks

Panic

Can i have something that will only display the cell contents?

thanks

Panic

Hello Panic,

I have included the modifications shown here in the attached workbook. I removed the control cell link in TextBox1. A worksheet event macro now updates the the TextBox1. The text box is also updated automatically whenever the UserForm is Activated.

UserForm code

Please Login or Register  to view this content.

[b]Sheet1 Event Code[/code]

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Hi Leith,

Thanks for the above!!!

This works perfectly, much appreciated!!

Panic