Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: combobox control

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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)


    Kind Regards,
    Ivan F Moala From the City of Sails

  5. #5
    Board Regular
    Join Date
    Mar 2002
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    cheers...

    i'll wotk that one!

    Ed

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •