RefEdit Control on Excel Form

[SonicBoomBand]

I'm trying to return a cell address into my code but can't seem to get any code to run once the RefEdit Control has been changed. The Change Event just crashes me out of Excel and the AfterUpdate Event just doesn't get called.

Has anybody got any ideas?

Andrew Chamberlain
National Grid Transco

 

[Crystalyzer]

Your post is kind of vague. I would guess that because you are using the "Change Event" and "After Update" that you are placing code into a sheet or workbook in these subs. If that is the case the "Target" variable IS the cell and you can reference it by using "Target" to get the following

 Target.address
Target.row
Target.value
Target.colum etc. etc. etc.

 

[Crystalyzer]

disregard my previous post. Must have been an LSD flashback.