Hello,
In column C I have the drop down option to select. When User select the Dropdown option I need current time to be displayed in adjustment cell in Column D.
How can I make that happen?
Thanks
Hello,
In column C I have the drop down option to select. When User select the Dropdown option I need current time to be displayed in adjustment cell in Column D.
How can I make that happen?
Thanks
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
no drop downs in column C
Not exactly sure what you want, this might be achievable through formulas, but sounds more like a change event subroutine for VBA
Would need expected results and some logic for when the date/time stamp gets changed (ie, initial choice, or status started, or finished, or a change in status, etc,...)
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Dropdown is in sheet1 of column C.
SO if it required a VBA, how can i move this to VBA section/??
Your uploaded sample has no dropdown's ( at least in version I downloaded) sorry
IF this requires VBA, PM a moderator or Administrator and ask them to move it for you, they are all good people, honest errors are fine
another upload i did, Weird I can see the drop.
Lookup the Worksheet.Change Event
Ben Van Johnson
I am still getting NO dropdowns, be sure the file your uploading is from the same place your saving to...if its not that I am bewildered myself...
when i download above file, I can still see the dropdown.. It might because of the version. I use 2010 Excel.
Thanks for the reply protonLeah, but I am not good with this.
Help me with few steps plz.
Thanks
I usually have no problems with 2010, but is a possibility I suppose
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks