Re: placing the date from the last row of a column into a Textbox in the Userform
Thank you for the efforts Robert. Cheers!
Posts by oren76
-
-
Re: placing the date from the last row of a column into a Textbox in the Userform
Thanks Robert for the ongoing help. Unfortunately that did not work.
I tried your code in module1 and I also tried changing "sheet1.select" to "mileage.select" and neither worked.
-
Re: placing the date from the last row of a column into a Textbox in the Userform
Robert,
Thanks for the reply. I used your code and it did not exactly work.
Upon launch of the userform textbox txtLastEntry has no information in it. But, once a new entry is made, txtLastEntry displays the data in whatever cell is mouse click higlighted. Not the last cell of column A and also not at initalization.
-
I am pretty new to VBA (and self learning) and I apologize if this has been asked, but I have been through countless of posts, pages and videos for 2 days and I can't get this to work.
forum.ozgrid.com/index.php?attachment/69157/
My workbook is called LYFT logThere is a (2) command button(s) that launch a userform, "cmdLaunchMileageLog" and the yet to be renamed "CommandButton1"
I have a worksheet named "Mileage"
I have a userform named "frmMileage"
In the userform there is a text box named txtLastEntryI would like txtLastEntry to display the last data cell entered in column A (a date) of worksheet Mileage when the userform is launched, so that the userform user doesn't have to go to the actual worksheet to know where they left off.
I have tried every code I have found and nothing seems to work. Can someone help me please?
Thanks so much.
-
Re: Can a Command button change colors when a check box is selected?
OK, I hope this helps. I really had to strip this to get it down in size but it shows the 3 sheets in the workbook. I appreciate any help.
-
Re: Can a Command button change colors when a check box is selected?
Fair enough. Done. Thank you for letting me know.
-
I'm very new to VBA and am kinda learning by the seat of my pants. I've created a workbook to do student Evaluations. The first sheet is the main evaluation form ("Evaluation") and it has command buttons to take you to each module for individual evaluation, for example ("Yard"). Each individual evaluation sheet has a series of check boxes, and those are referenced and collected on a sheet called ("Checkboxes").
Whenever one of those individual sheets have any check boxes selected ("TRUE") I would like the color of the command button associated with that sheet to change colors (green). Whenever the boxes are unchecked I want the associated command button to go back to white. I can't for the life of me figure a way to make that happen.
In lines with Cross Post rules, I have also asked this on another Forum first and haven't gotten an answer yet.