| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell data change formatting
I have a user form where cell A1 is a input field for "WeekNo., No of days,
or Date. The date is selected by use of the build in calandar. The range A2-A12 are referenced to A1+1, A1+2 etc. This works fine, as long the Date is not used, because the Calendar will convert the formatting of the cell to the "date" format. The formula: & Text(today(),"mm/dd/yy") cannot be used as this format the Cell to text, not allowing the range A2-A12 to be updated when the date is selected. Your help or guidance is appriciated. thanks. Paco.E |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change date formatting in destination cell | Excel Discussion (Misc queries) | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Excel data formatting change on Mailmerge | Excel Discussion (Misc queries) | |||
| Change Formatting In 'Active' Cell | Excel Discussion (Misc queries) | |||
| Cell color change without using conditional formatting | Excel Discussion (Misc queries) | |||
Threaded Mode
