Userform using RefEdit to get a range

LisaGreen · Post by **LisaGreen** » 23 Dec 2018, 22:00

Hello everyone,

This is a form, and a sub to use it, to get a range from an excel sheet.

It uses RefEdit and is all VBA and no API thingies. I was intrigued by someones attempts to do this so here is my attempt.

You can easily add the xlsm as an add in or add the code and form it to you own add-in code.

At the moment it returns a string but could equally well return an object like "selection".

If anyone has any problems with it please get back to me!!

Regards
Lisa

Post by **HansV** » 23 Dec 2018, 22:25

1) I noticed that I cannot switch to another open workbook.

2) I get an error when I click Cancel:

S0015.png

smRange should be smGetRange (multiple times).
I had to crash Excel to get out of this.

LisaGreen · Post by **LisaGreen** » 23 Dec 2018, 22:29

Hans!!!

Thank you!!!!... And many sorries!

Working on it!

Happy Christmas my lovely friend!

Lisa

LisaGreen · Post by **LisaGreen** » 24 Dec 2018, 15:58

Here's a new copy!!!

Tested this as much as I can.

Many apologies for the previous one!

Lisa

Post by **HansV** » 24 Dec 2018, 16:14

That works better!

LisaGreen · Post by **LisaGreen** » 24 Dec 2018, 16:16

Phew!!!!!

Eileen's Lounge

Userform using RefEdit to get a range

Userform using RefEdit to get a range

Re: Userform using RefEdit to get a range

Re: Userform using RefEdit to get a range

Re: Userform using RefEdit to get a range

Re: Userform using RefEdit to get a range

Re: Userform using RefEdit to get a range