show changing activecell value in floating userform

**tenk283** · 09-26-2010, 01:26 AM

I have a floating userform showing various statistical information as the user clicks on different cells. To have the userform working and changing, how can I link the changing cell ref into the userform so each change to the cell triggers a recalculation of the data displayed on the userform?

**pike** · 09-26-2010, 01:36 AM

Dude,
Place this in the workbook module

Please Login or Register  to view this content.

and this in a module

Please Login or Register  to view this content.

assumption that you have userform1 with textbox1 on it

**pike** · 09-26-2010, 01:42 AM

Dude,
can you please change the thread title to somthing like "show activecell value in userform"

**tenk283** · 09-26-2010, 01:49 AM

Originally Posted by pike

Dude,
can you please change the thread title to somthing like "show activecell value in userform"

Title Changed and Solved added.

Thanks again Pike. Another perfect solution.

**pike** · 09-26-2010, 01:55 AM

no problems Thanks for taking the time to comply and mark post solved

.

**tenk283** · 09-26-2010, 02:14 AM

Originally Posted by pike

no problems Thanks for taking the time to comply and mark post solved

.

Whoooo!!! Brownie points!

Please Login or Register  to view this content.

I do have a question though.

How does the above code pick up a change in the worksheet?

Is it the sub title "SheetSelectionChange" that Excel picks up on?

Also, the ByVal statements, what do they do? Can you point me to some info on the matter?

**pike** · 09-26-2010, 02:25 AM

hi tenk283
because its in the workbook module
It Occurs when the selection of a cell changes on any worksheet
(you could put it in just worksheet module )the target is the new selected range.
and the by value is the where the value is stored and will stay the same in the procedure
as apposed to by ref which changes
the best place to learn is in the vba help files they have heaps of good explinations and examples