Results 1 to 2 of 2

Thread: Add the value taken from the user to my range for ActiveX ComboBox

  1. #1
    Junior Member
    Join Date
    Aug 2022
    Posts
    2
    Rep Power
    0

    Add the value taken from the user to my range for ActiveX ComboBox

    Hi everyone,

    I defined


    a ActiveX ComboBox named "cmbPeymankar",
    a Text Box (ActiveX control) called "txtNewPeymankar".
    a Command Button (ActiveX control) called "Add".


    I have a table named "Table1" in sheet "DATA" so that the first column of Table1 contains the names that should be displayed in the cmbPeymankar list and 10 items are already written in it.

    I have three questions:


    How to define the value of "ListFillRange" of cmbPeymankar so that the values of column 1 of Table1 are displayed in its list?
    What command should I write for Add button to add the value taken from the user for txtNewPeymankar to the end of the column 1 of Table1?
    The value of cmbPeymankar can be selected from its list. If the user wants to type its value, how can I write an error message if the entered value is not equal to any of the predefined items for cmbPeymankar (in column 1 of Table1)?

  2. #2
    Member p45cal's Avatar
    Join Date
    Oct 2013
    Posts
    94
    Rep Power
    12
    Cross posted left, right and centre.

Similar Threads

  1. Replies: 5
    Last Post: 06-13-2014, 08:37 PM
  2. Replies: 2
    Last Post: 05-22-2014, 08:43 PM
  3. Replies: 4
    Last Post: 11-15-2013, 03:42 PM
  4. Replies: 8
    Last Post: 08-17-2013, 04:03 AM
  5. Combobox with Dynamic Date Range
    By paul_pearson in forum Excel Help
    Replies: 5
    Last Post: 07-21-2013, 06:14 PM

Tags for this Thread

Posting Permissions

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