Hello Dear Members,
My question is about ListBox.
I have a table in which shown information about workers and this table is dynamic.
Actually this table is my database relate to workers' information.
Sometimes I need to make some changes on date, so I need to bring that data into list box.
Here is my code:
I got debug with last part.
Thanks in advance!
Please Login or Register to view this content.
There are multiple issues with your code...
1. While you use "With... End With" you didn't use "." in front of Cells. So it's using ActiveSheet regardless of Worksheet specified.
2. ".RowSource" does not belong in "With... End With" it should be qualified with ListBox.
3. From "EditData.Show" I assume the listbox is in the userform. You should have code to load listbox with data in UserForm initialize event.
Here's sample code using Excel Table to fill listbox.
See attached sample as well.Please Login or Register to view this content.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
CK76 I am grateful to you for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks