VBA for EXCEL
Posted on 2001-06-20
I have created a user form with a mulitsheet tab, called mulitsheet1 that has three tabs, which are called
GENERAL INFO TROLLEY DETAILS TROLLEY POSITION
On the GENERAL INFO sheet, there is an input box called weight, which asks for a value (integer). There is a routine which checks to ensure that an integer value has been entered and will give a message if this is not the case. I also want to prevent the user from being able to select different tabs, such as TROLLEY POSITION, until a value has been entered, but have not been able to successfully write a routine to do this. I have written code in the ?click event? for the GENERAL INFO tab, that sets the event to false if the input value is not an integer, but is does not work..
I imagine this should be straightforward and involves using the index property, but I am becoming increasingly frustrated. Could someone please advise on where I am going wrong and a sample of code I should incorporate into my module.