Member Avatar for niksirat

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:

  1. How to define the value of "ListFillRange" of cmbPeymankar so that the values of column 1 of Table1 are displayed in its list?
  2. 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?
  3. 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)?
Edited by Dani because: Sorry, moved back to MS Windows forum
  • 2 Contributors
  • 1 Reply
  • 31 Views
  • 37 Minutes Discussion Span
  • Latest Post Latest Post by Dani
Member Avatar for Dani

This it not my forte but I just wanted to jump in here and apologize for moving this question to our programming forum. I’ve moved it back to the MS Windows forum after googling your problem and seeing it’s related to Microsoft Excel. Is that correct?

Good luck! Hopefully someone who can help will be around to help soon.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.