RUN CODE ONE TIME _Click event

[Undo]

Hello

How can I run my macro one time only if I select the textbox?
mean if I click on textbox, code run 1 time only, and it back to work again only if I leave the textbox and enter it again
What code sould I use in Private Sub TextBox1_Change() ?
macro name : macro1

Thanks

[Richard Buttrey]

One way would be to set a 'flag' in an Excel cell and test for the flag in the macro.

So Enter say the word "First" in a cell named say 'CheckFirst"

Then in the macro use something like

Please Login or Register  to view this content.