I have this code, and want to restrict it two 2 named ranges instead of the entire worksheet. What is best way to do this. Not very familiar with VBA.
Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
ActiveCell.Value = Now()
Application.SendKeys "^{return}"
Target = Format(Time, "h:mm:ss")
Cancel = True
End Sub
Something like:
Not sure what the Sendkeys command adds to this...?
Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Why are you using SendKeys?
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for your help, Jacc that worked.
Not sure what the SendKeys does either.
Honestly I copied this from somewhere else, and modified it to turn my worksheet into a data collection sheet that allows me to click a cell to add the time stamp and calculate the total duration of the row.
From what I can see, I'm not entirely sure that SendKeys statement is valid. I assume it is meant to be, maybe, Crel-Enter.
https://docs.microsoft.com/en-us/off...keys-statement
Note that thisputs the Date AND Time in the Active CellPlease Login or Register to view this content.
While thisputs the Time in the Target CellPlease Login or Register to view this content.
The Active Cell and Target are the same cell, in this instance, so the second statement overwrites the first.
So, all you really need is:
Or, my version:Please Login or Register to view this content.
Please Login or Register to view this content.
Thank you for the help. I am familiar with SQL (self taught), but if I am decoding this properly it looks like I could put a second if statement before the end sub to perform a second function (ie enter y in active cell in a different named range when I double click the cell)
BTW your option is much cleaner code. I really appreciate your feedback you provided.
Last edited by heismanasu; 11-19-2020 at 02:19 AM.
Yes, maybe this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks