dorsa niksirat
New Member
Members
Forum Posts: 2
Member Since:
August 27, 2022
August 27, 2022
Offline
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)?
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1909
SunnyKow: 1432
Anders Sehlstedt: 899
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 279
lea cohen: 245
Jessica Stewart: 219
A.Maurizio: 213
Newest Members:
Sheila Sanders
Francine Walshe
Sean Ladlow
Jorge Chicas
mahmoud salem
Irvine Choolo
Deon Bouwer
Amgad Squires
jim bo
Linda Bock
Forum Stats:
Groups: 3
Forums: 24
Topics: 6836
Posts: 29985
Member Stats:
Guest Posters: 49
Members: 33568
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —