The easiest and most flexible way to do this is to click on the cells with the numbers, rather than adding buttons.
"The number clicked needs to be used in another cell." That's a little vague so I didn't know what to do with the number. In this example the clicked number goes into E5. Modify code to suit.
Hello and thanks. A click of a number would work just great.
I can't upload another sheet or I just don't know how to, but what I need is the 1st number clicked to be put into Cell A5. The
2nd number clicked to be put into Cell A6. The next number clicked to be put into Cell A7. etc.
As always thanks for your help.
Nick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks