Hello Community,
I have searched, but havenīt found a solution.
I would like some code to select a row of cells left of a placed ToggleButton.
Hereīs what Iīve got so far:
The problem is, that in this case, I first have to make a Cell activ in the row of my button.
Please Login or Register to view this content.
What I would like, is a solution without this step.
Thanx in advance
P.s. If somebody already posted a solution, I would be happy with the link
Last edited by Arrahed; 08-23-2012 at 09:41 AM.
Hello there,
In Design Mode right click on your Toggle button and select the View properties option. Scroll down to the Linked Cell option and in the field provided type the range of the cell that is located underneath your toggle button. For instance if you toggle button was placed over cell A1 you would type A1 into the space provided.
Then update your code so that it looks like the following
Please Login or Register to view this content.
Hello rvasquez,
Very helpfull, tnx very much.
Could also tell me if I can make the LinkedCell property relative, so that it will chang when I copy the button?
Greetings and tnx again
Hello there,
Kindly disregard what I have deleted I don't believe it is working.
The below code should work instead without having to set the linked cell property
Thanks!Please Login or Register to view this content.
Last edited by rvasquez; 08-23-2012 at 10:37 AM.
Hi rvasquez,
Nope, that doesnīt work.
With this code, it only jumps to the column, not the row.
Although I could shorten the code a bit, Iīm still looking for a possibility to copy the button and thereby adjust the LinkedCell property.
It now looks like this:
Ups that was too fast. Iīll try your solution tomorrow. Workday is over =)Please Login or Register to view this content.
Last edited by Arrahed; 08-23-2012 at 10:48 AM. Reason: Replie too fast... ;)
Hi rvasquez,
Works like a charm.
Iīve shortened the code to what you see below.
There is only one problem that still persists.Please Login or Register to view this content.
I would like this button to be pastable.
Otherwise this complete procedure would be useless, because it is way to time-consuming to change the code for every single button.
Therefore, the code (as I understand it) has to be relative.
Anyone?
Dear all,
Is there somebody hwo can help me out with this problem?
I still havenīt found a passable solution.
Tnx up front for anything usable.
Hello,
Anybody still out there with a solution.
Or did I just find a totaly useless solution?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks