Need Macros (1 Viewer)

mahen

Registered User.
Local time
Today, 09:33
Joined
Jan 13, 2008
Messages
56
I need a macro(s) to perform the followings in my MASTER worksheet.

1. a popup message should come with Enter starting date. When enter date, it should change on B6.

2. Another popup message should come with enter deadline dates. It should be able to enter two dates and it should replace A38,

3. All these are changed the 'MASTER' sheet, it should change samething in rest of the sheets.
Attached sample sheet.

thank you.

- Mahen
 

Attachments

  • Master.xls
    77.5 KB · Views: 105

Trevor G

Registered User.
Local time
Today, 09:33
Joined
Oct 1, 2009
Messages
2,341
If you haven't solved this this code will do what you have asked for, in the workbook use Alt + F11 (into VBA) the use the Insert Menu and Module copy and paste the code below, then test it out.

Sub checkmeout()
Range("B6") = InputBox("Please enter the date")
Range("A38") = "Manual Sheets by: " & InputBox("Enter the first date") & " and GTS Reports by: " & InputBox("Enter the second date")

End Sub
 

mahen

Registered User.
Local time
Today, 09:33
Joined
Jan 13, 2008
Messages
56
Tevor,
This excellent. worked pefectly. Thank you so much.

- Mahen
 

Trevor G

Registered User.
Local time
Today, 09:33
Joined
Oct 1, 2009
Messages
2,341
Your welcome and thanks for replying to let me know it helped you.
 

Users who are viewing this thread

Top Bottom