Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit a cells content via a dialog box?
Hi, I would like to edit a cells content via a dialog box or message box. The reason for this request is because I have a need to update a date and machinary part in a maintenance log. I have used input boxes and message boxes in the past, however, editting a known cells contents without actually going to that cell on the sheet is really what I am after. Thanks in advance. Regards, Wazza McG -- Wazza McG ------------------------------------------------------------------------ Wazza McG's Profile: http://www.excelforum.com/member.php...o&userid=36785 View this thread: http://www.excelforum.com/showthread...hreadid=564979 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit a cells content via a dialog box?
Hi Wazza,
dim strDate as string 'set default date strDate =date() do strDate=inputbox("enter date","maintenance date",strdate) 'check whether cancelled if len(strDate)<1 then 'user clicked cancel end if 'loop if user entered a non date value loop until isdate(strDate) 'store date in cell Worksheets("name of sheet").range("E2")=strDate ' E2 could also be name of named cell hope this gives you some ideas to work with Luck Jonathan "Wazza McG" wrote: Hi, I would like to edit a cells content via a dialog box or message box. The reason for this request is because I have a need to update a date and machinary part in a maintenance log. I have used input boxes and message boxes in the past, however, editting a known cells contents without actually going to that cell on the sheet is really what I am after. Thanks in advance. Regards, Wazza McG -- Wazza McG ------------------------------------------------------------------------ Wazza McG's Profile: http://www.excelforum.com/member.php...o&userid=36785 View this thread: http://www.excelforum.com/showthread...hreadid=564979 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit Link Dialog Box | Excel Discussion (Misc queries) | |||
Using RichTextBox to edit Cell content | Excel Discussion (Misc queries) | |||
Link content from dialog box to a worksheet cell | Excel Discussion (Misc queries) | |||
A Macro to Edit Cell Content | Excel Programming | |||
Show Dialog Box - Edit/Replace | Excel Programming |