Hi,
been using below code to allow me to put a value in any cell and update all sheets across top 3 rows.
I would like it to be able to still do this but it doesnt seem to work with Ticks but only numbers and words
[/QUOTE]
Please Login or Register to view this content.
Hello,
What do you mean by a "Tick"?
According to Wikipedia.
Ticks are small arachnids
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yes, and damn gross when you look at them in a microscope.Originally Posted by bakerman2
According to Wikipedia.
check the attachment - the character (tick sign) i.e tick a box Haha
How are those ticks inserted in worksheet??
Anybody else see an attachment?
Ok, I found your attachment from a previous thread.
In your double-click event you are setting enable events to false, therefore the worksheet change event will not kick in.
Sorry about that - So if I set that to True will it then work coherently with the above code? and allow the tickboxes to also copy on to each page regardless of which tab I double click on? or will I only be able to use the above code to replicate numerical and letters?
If I read your question correctly, I believe the worksheet change event will only kick in with the active sheet
Yes What I am saying is when I input that code on a blank worksheet, it will allow me to enter any information on any sheet along the top 3 rows and have that update all the other sheets with the same data.
However when I used a Tickbox VBA to see whether I could do the same with this across all sheets - it doesn't recognise when a tick is in a box but it will recognise the number 1 for example.
Try copying that code to a blank workbook and then use a tick character in a cell and you will see the numbers and letters will work but tick signs do not for some reasons.
thanks,
Are you talking about checkboxes?
When you check a checkbox, the worksheet change event does not kick in?
Exactly yes!
Can you supply a sample, so we don't have to keep guessing what you are talking about?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks