When making a random number generator would you get a more random answer if adding 100,000, then after it's answer remove 100,004 back to the six that are needwd for a dice? Sorry I always ask stupid questions.
hello sir, my name is Yasser from Egypt ,and i like your videos and following you long time ago. i wish my message finds you well and safe and i hope you answer my question which is" may i create a button to clear specific fields and keep the record as it is, thank you so much, can't wait for your replay.
Hi Richard, Excellent instruction, Thankyou. Do you have any guiding light youtube videos on navigating objects, I saw example in excel using "comments" object and a user has to open the correct im thinking it was "5" objects in the user vba help file out of the 200+ shown objects in the help index to connect thru code "comment" thru 5objects to enable then to colour in the comment box background .. of the comment object.which itself does not have a color method/property . Is there a map, a published directory or a better way to connect the dots to save a lot of time driving around town somewhat lost.. i know some are hierarchical and easy. Application.sheet etc. Nice instruction videos Vba objects sometimes returns a object but the help file says no more than this .. it happens, i believe to be range object it returns.. How would a NEW user SEE this please ?? I only read this example so was able to check. Might help unlock obstacles. Thanks for all your channel work.
Should say 7 objects.. thus:- (no reply edits being allowed here today apparantly)...oops Application(excel)workbookobjectworksheetobjectcommentobjectshapeobjectfillformatobjectcolorformatobjext
Good, but what i was looking for was how to calculate a table field (Age) invoking a VB function (Age()), passing it as parameter the content of another field (Age(Birthdate)) ...which implies that that function also knows what date is today (Now())....i found the code for that function on the internet but i dont know how to invoke it .....please help!
All your videos are one to one. Thanks
You're welcome... I think. :)
Good Lesson, quick & simple.
If not Randomize, will the function always generate the same number ?
Maybe. Maybe not. Ha ha. It's likely, yes.
When making a random number generator would you get a more random answer if adding 100,000, then after it's answer remove 100,004 back to the six that are needwd for a dice?
Sorry I always ask stupid questions.
I don't understand why you would do this or why it would be necessary
I am a gold member ... I have no access to members-only TH-cam videos. plz, help.
If you signed up on my site, you can only watch them on my site.
thank you
You're welcome
hello sir, my name is Yasser from Egypt ,and i like your videos and following you long time ago. i wish my message finds you well and safe and i hope you answer my question which is" may i create a button to clear specific fields and keep the record as it is, thank you so much, can't wait for your replay.
599cd.com/Ask
Can someone explain better that "maximize" at 9:03?
Keep watching. 11:00
Great teacher...
Thank you! 😃
Hi Richard, Excellent instruction, Thankyou.
Do you have any guiding light youtube videos on navigating objects, I saw example in excel using "comments" object and a user has to open the correct im thinking it was "5" objects in the user vba help file out of the 200+ shown objects in the help index to connect thru code "comment" thru 5objects to enable then to colour in the comment box background .. of the comment object.which itself does not have a color method/property . Is there a map, a published directory or a better way to connect the dots to save a lot of time driving around town somewhat lost.. i know some are hierarchical and easy. Application.sheet etc.
Nice instruction videos
Vba objects sometimes returns a object but the help file says no more than this .. it happens, i believe to be range object it returns.. How would a NEW user SEE this please ?? I only read this example so was able to check. Might help unlock obstacles. Thanks for all your channel work.
Should say 7 objects.. thus:- (no reply edits being allowed here today apparantly)...oops
Application(excel)workbookobjectworksheetobjectcommentobjectshapeobjectfillformatobjectcolorformatobjext
I'm sorry, but I'm not following you...
Good, but what i was looking for was how to calculate a table field (Age) invoking a VB function (Age()), passing it as parameter the content of another field (Age(Birthdate)) ...which implies that that function also knows what date is today (Now())....i found the code for that function on the internet but i dont know how to invoke it .....please help!
599cd.com/Age
You aren’t old 😭 my birthday is 1985…but October 23 is also my dads birthday 😁