Link to home
Start Free TrialLog in
Avatar of GrahamSA
GrahamSAFlag for South Africa

asked on

MsgBox to populate a cell once another cell is populated

Hi

Just want to say thank you for all the help, this project is starting to look great!!

OK.

This spreadsheet has a "Date" column and on the other end there is a column called "Standing Time"

Here is what needs to happen, once I add the date and try move from that cell a MsgBox needs to come up. ("Please add your Standing Time Hours __________") then once added the number populates the relevant cell then the MsgBox asks ("Did you fill in a Standing time Note") Yes/no

The Yes/no does not have to do anything but be a confirmation that the note is filled in.

Hope that this is a fun one :)
I think i would have fun with it if i new how.


Spreadsheet layout attached
 Standingtime.xlsx
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

this code should start you going:
will need to be added to the worksheet module...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("A2:A9999")) Is Nothing Then
    answer = InputBox("Enter Standing", "Title")
    Cells(Target.Row, 2) = answer
End If

End Sub

Open in new window

Example.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GrahamSA

ASKER

Awesome!
How do I get the last message that asks (did you fill in a Standing time form)?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you very much.
Perfect