RefEdit remove anchor

[Curare]

Hello all,

I'm creating a userform that will reference specific cells using the RefEdit control. Is there a way to remove the anchor from the reference within the userform? For example, the RefEdit control box will give me "Sheet1!$A$1", but I want it to show "Sheet1!A1" instead.

Thanks.

[rylo]

Hi

How about something like

Please Login or Register  to view this content.

Once you move away from the control, it will update the value.

If you just want to use the value, you could leave the refedit as it stands, and remove the $ before using the result.


rylo

[Curare]

Awesome! That works.

Thanks!

[Leith Ross]

Hello Curare,

This method will work for single cells and multiple cells, even if they aren't contiguous.

Please Login or Register  to view this content.

Sincerely,
Leith Ross