trigger textbox change event

Av8tordude

Well-known Member
Joined
Oct 13, 2007
Messages
743
I'm using the code below to fill a textbox with a number and triggers a change event once filled. However, if the number is the same on the next row, it does not trigger the change event. How can I trigger the change event if the number is the same?

Code:
tbOQty = Range("F" & ActiveCell.Row)
 

NoSparks

Well-known Member
Joined
Mar 15, 2013
Messages
859
Office Version
2010
Platform
Windows
The change event isn't triggered because there is no change.
Don't use the change event.
Use a separate macro and call it from a code line right after this one.
 

Forum statistics

Threads
1,086,118
Messages
5,387,933
Members
402,090
Latest member
thomastsiakis

Some videos you may like

This Week's Hot Topics

Top