View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] singh352@hotmail.com is offline
external usenet poster
 
Posts: 7
Default Enter Text or Date on Multiple Sheets

Hello Experts,

I am using Office 2003 and have the following problem:

I wish to insert certain text or date in a particular cell in all the
sheets in the workbook:

I am looking a vba a solution as follows

1) A message box should appear and ask for the text or date to be
entered.
2) Another message box should ask for the address where the text should
be entered eg. B15 or other

The text or date entered in 1) above should appear in the cell address
in 2) on all the sheets in the workbook

Hope I am clear.

Is this possible?
TIA

Ashish Kumar