check if Userform textboxes are dirty (Me.dirty)

[laurawr]

Hi,

I have a form that is used for editing data in a spreadsheet.

First my code retrieves the data from a listview search facility and it then goes into several text boxes for editing.
Once edited the user must click an "update" button and this writes the new data to the spreadsheet.

The problem:
On the button click, I want the code to check if the form data in various text boxes have been edited at all, and then to display a message box to say
no fields have been edited if the data hasnt changed. at the moment the button click just updates the spreadsheet whether data has been edited or not.

Looking around I see that me.dirty could solve the problem. However i'm completely baffeled at how to use me.dirty after many attempts.


If you could help me I would be most appreciative.
Any other suggestions are welcome

Thanks

L

 

[Norie]

Laura

As far as I'm aware you can't use Dirty with userforms in Excel.

It's usually associated with Access forms, which are more then likely bound to a record source.

Couldn't you just monitor the Change and Exit events of the textboxes?

 

[laurawr]

ahhh I see.

Thanks for enlightening me

yep i suppose i could try that.

Thanks