Re: [MS_AccessPros] Add Items to Listbox from inputbox

 

Hi Art,

One step at a time. Did you really mean "have that added to the inputbox"? I expect you wanted to add items to your list box.

1) use the InputBox() function in VBA to get input from a user.

2) use the AddItem method in VBA to add an item to a list box 

3) once you get this working and understand it, then you can continue with the remainder of you question.

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Friday, October 20, 2017 1:45 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Add Items to Listbox from inputbox

 

I have a frmMain and on it, there is a command button called cmdAddIndexes and a listbox called lstIndexes.  I need to be able to click cmdAddIndexes which opens the InputBox and then enter text click OK and have that added to the inputbox.

When the text is added to each line in the listbox it also needs to be copied to a invisible field called IndexLabel1 or IndexLabel2 or IndexLabel3 through IndexLabel10 given how many lines were added to the listbox from the Inputbox. These fields will be written to the table later.

Thank you ,

Art Lorenzini

Sioux Falls, SD

__._,_.___

---

Posted by: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___