Hi! I am working on an excel model for a client, so I need for it to be extremely user friendly.
I am trying to use the double click on the command button to send the user to a new range of cells. In other words, they will start with a view of one range of cells in which there are a number of inputs requested of them. Once they have completed all of the necessary inputs, I would like for them to double click the command button, which should then take them to the next section of inputs.
How do I write a VB code that will actually change the view/focus? I have tried to use Range(cells).select, but that hasn't worked for me. I am new at this, so maybe I did not enter the code quite right.
Please help!
Thank you in advance,
Emily
I am trying to use the double click on the command button to send the user to a new range of cells. In other words, they will start with a view of one range of cells in which there are a number of inputs requested of them. Once they have completed all of the necessary inputs, I would like for them to double click the command button, which should then take them to the next section of inputs.
How do I write a VB code that will actually change the view/focus? I have tried to use Range(cells).select, but that hasn't worked for me. I am new at this, so maybe I did not enter the code quite right.
Please help!
Thank you in advance,
Emily