trigger textbox change event

[Av8tordude]

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?

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

 

[NoSparks]

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.

 

[Av8tordude]

I was afraid you would say this...Thnx for the clarification. cheers