Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

How to Program range input boxes VBA Excel

shizz · 2011-11-13 15:34:56

Ok so I have an input box asking the user to select a range of cells. It all works fine if they actually do that, but I don't know how to program the Close button and the cancel button on the range input box. Can anyone help?

13-11-2011 04:34PM

#1

shizz

Registered Users, Registered Users 2 Posts: 1,506 ✭✭✭

Join Date: February 2010

Posts: 1435

Ok so I have an input box asking the user to select a range of cells. It all works fine if they actually do that, but I don't know how to program the Close button and the cancel button on the range input box.

Can anyone help?

0

Comments

#2 14-11-2011 12:55PM

FSL

Registered Users, Registered Users 2 Posts: 1,456 ✭✭✭

Join Date: February 2006

Posts: 1419

How exactly are the users selecting the range of cells?

If you press cancel on an input box it just returns an empty string.

0
#3 14-11-2011 08:34PM

shizz

Registered Users, Registered Users 2 Posts: 1,506 ✭✭✭

Join Date: February 2010

Posts: 1435

It was an input box of type 8 which takes in ranges. I just wanted to be able to produce a message box asking if they wished to exit when they pressed either the close button or cancel. I figured out how anyway. Thanks.

0