combobox control

Jackeb · Apr 15th, 2002, 02:01 AM

Quick question...

Where can I find out about displaying dates in comboboxes, the format changes everytime i use them, how do you control this? Is there a property of the box?

Cheers

Ed

Ivan F Moala · Apr 15th, 2002, 02:15 AM

Use the Comboboxs change to change the
formating of the dates eg.



Private Sub ComboBox1_Change()

ComboBox1.Text = Format(ComboBox1.Text, "dd/mm/yyyy")

End Sub

Jackeb · Apr 15th, 2002, 02:17 AM

I have tried this but it effects some other calculations, without having to rewrite my logic is there an easy way to solve this problem??

ed

Ivan F Moala · Apr 15th, 2002, 02:31 AM

Quote:

On 2002-04-15 01:17, Jackeb wrote:
I have tried this but it effects some other calculations, without having to rewrite my logic is there an easy way to solve this problem??

ed

Ed there is no property to control this.
What calculations are affected, as you can always change the text back to its original
serial date format for calculations eg.

CDate(ComboBox1.Text)

Jackeb · Apr 15th, 2002, 02:43 AM

cheers...

i'll wotk that one!

Ed

Apr 15th, 2002, 02:01 AM	#1
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	Quick question... Where can I find out about displaying dates in comboboxes, the format changes everytime i use them, how do you control this? Is there a property of the box? Cheers Ed __________________ Ed Jackson "Do not worry about your problems with mathematics, I assure you mine are far greater." A. Einstien

Apr 15th, 2002, 02:15 AM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Use the Comboboxs change to change the formating of the dates eg. Private Sub ComboBox1_Change() ComboBox1.Text = Format(ComboBox1.Text, "dd/mm/yyyy") End Sub __________________ Kind Regards, Ivan F Moala From the City of Sails

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 15th, 2002, 02:17 AM	#3
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	I have tried this but it effects some other calculations, without having to rewrite my logic is there an easy way to solve this problem?? ed

Apr 15th, 2002, 02:43 AM	#5
Jackeb Board Regular Join Date: Mar 2002 Posts: 81	cheers... i'll wotk that one! Ed