-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
mytime
-
E
Convert Time to static/constant value
Hello, i am not so good with VBA. Can anyone please help me understand how can i get the system current time and keep it as a constant value? Sub Button1_Click() Dim MyTime MyTime = TimeValue(Time) MsgBox (MyTime) ModTime = MyTime + TimeValue("1:12") MsgBox (ModTime) End...- Exceladd1ct
- Thread
- modtime msgbox mytime system time
- Replies: 3
- Forum: Excel Questions
-
S
New to the forum and new to VBA
Hi, I am having the fun task of converting some Google sheets to Excel sheets, the google sheets have some javascript with that I need to change to VBA to enable the functionality in the final excel sheet. I am looking to do some thing simple really, when someone enters a value into Col A I...- SirReal31
- Thread
- add application.enableevents col end mytime
- Replies: 5
- Forum: General Discussion & Other Applications
-
K
Excel VBA Type Mismatch error
Hi, I am applying vlookup functionality through Dictionary object, and it is working fine if the lookup value is less than or equal to 70000, I am holding lookup data in the variable "mydata2", but if the lookup value is more than like 80000, it is giving my an "Type Mismatch" error in the...- kashif.special2005
- Thread
- dim lookup mydata2 mytime variant
- Replies: 9
- Forum: Excel Questions
