• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Display Column Headers in Combobox ( after using the List property to populate the ComboBox)

M

martinargimon

Member
In my ‘Orders’ Sheet I have a button to call the ‘Data Entry Form’ ( top right)
To enter a ‘New’ Order first press New Order button ( at the top right corner) , then proceed to add an order number ( example, 29, 30 ,32 ,etc) , enter any Policy number and select any “Customer No” from the ComboBox.
Next click on the ‘Property type’ comboBox… ( this is the control I would like it to display the Column headers). I did set the ‘Column Heads’ property of the comboBox to ‘True’ but is does not display the headers, unfortunately.
Bear in mind that I’ve used the ‘List property’ to populate the ComboBox under the Sub_routine Initialise.
 

Attachments

  • MEM Database 2022.03.07_Extract.xlsm
    384.5 KB · Views: 8
hi there
I see that my thread is 'highlightred' as watched.. Not too sure what it means ???. IS there a problem>?
Kindly let me know so i can consider other alternatives
Many Thanks
Regards
Martin
 
The columnheads property has no effect unless the control is linked to a range on a worksheet.
 
You can't use the list property if you want to display the headers, you have to use RowSource property.
Code: 
CmbBox_PropertyType.RowSource = "Rng_Properties"
 
You must log in or register to reply here.
Back
Top