Consulting

Results 1 to 2 of 2

Thread: Putting temporary data in a Combobox

  1. #1
    VBAX Regular
    Joined
    Mar 2009
    Location
    Stowmarket
    Posts
    62
    Location

    Putting temporary data in a Combobox

    I am sure I have done this before, but I seem to have brainfreeze !!!

    I am populating my ComboBox from a TXT file.

    I want my ComboBox, when it displays, to say "Please Choose From The Following Options" & then when the user clicks on the DropDown arrow, the data from the TXT file displays.

    This data is used in different places, so I can't add the "Please Choose ..." line at the top of that file & display it as the first option ...

    However, when I use the lines

    [VBA]UserForm1.ComboBox1.Value = "Please Choose ..."[/VBA]

    or

    [VBA]UserForm1.ComboBox1.Text = "Please Choose ..."[/VBA]

    I am just getting an empty box ... I am sure I am going to be embarrassed when somebody tells me what I am doing wrong, but hey, I'll accept my ridicule !!!!!

  2. #2
    VBAX Regular
    Joined
    Mar 2009
    Location
    Stowmarket
    Posts
    62
    Location
    OK, I have done it in the design, by putting the text into the Value field, I am unable to enter into the Text field for some reason, but it works, so I am happy !!!

    Case Closed, as they say ...

Posting Permissions

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