How to enter a value in VBA code using listBox

[Karthik Thandapani]

Hello,

Recently @Debraj helped me to add a range into a listbox. Now I looking for some help to enter the user feed value into the VBA code. Say, if user is entering an email id, that should be captured in another macro and run that module. Please let me know if you need more information. Is it woks the same way how an input box works? Please help

Please check the attached file. I have included more details there.

Thanks,
Karthik

 

[vijay.vizzu]

Hi.. karthik

You can do this by referencing the varaibles.. like if you have email address text box, to capture the mail address which the user entered, you can declare a variable like dim EmailAddr as string and capture the text box value.

more or less same.. below. Here we instruct text box that, after the user input completed, then please assign that value to variable namely emailaddr. Same as for another also.. I hope you can understand

Private Sub txtEmailAddr_AfterUpdate()
    emailAddr = txtEmailAddr.Value
End Sub

 

[Karthik Thandapani]

Excellent. Thanks a lot vijay