Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo Box - Data format
I have a Combo Box that has a linked cell reference to a
cell that contains a date value. The Date Value is "=NOW ()" by the way. The combo box is displaying the numeric date value - how can I format this to read as a date? I also wanted to then use an up down control (or even better one of those controls that lets you pick a date off of a calendar). So how do I make it display a date and how do I let the user modify this existing date? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Combo Box - Data format
Hi Dan,
You can use Format function and Change event. Place this code in worksheet module(or Userform modele??, I'm not sure where the combobox is.) Private Sub ComboBox1_Change() ComboBox1.Value = Format(ComboBox1.Value, "d/m/yyyy") 'Change here as you like! End Sub -- Kind Regards Colo /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Colo of 'The Road of The Cell Masters' :) URL:http://www.interq.or.jp/sun/puremis/...astersLink.htm /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ "Dan" wrote in message ... I have a Combo Box that has a linked cell reference to a cell that contains a date value. The Date Value is "=NOW ()" by the way. The combo box is displaying the numeric date value - how can I format this to read as a date? I also wanted to then use an up down control (or even better one of those controls that lets you pick a date off of a calendar). So how do I make it display a date and how do I let the user modify this existing date? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format a combo box to show mmm-yyyy format | Excel Discussion (Misc queries) | |||
Can one combo box control the data in a different combo box | Excel Discussion (Misc queries) | |||
add data to combo box in excel then invoke macro | Excel Worksheet Functions | |||
Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
How can I avoid excel saving xla combo data? | Excel Programming |