If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

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 3: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 11:55am

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 7: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