LinkBack URL
About LinkBacks
hi,
Is it possible to refresh a Userform As i input data Sheet1.range(h10:h1000") using worksheet change event
thank you
hi,
Is it possible to refresh a Userform As i input data Sheet1.range(h10:h1000") using worksheet change event
thank you
Use Code-Tags for showing your code :
Please mark your question Solved if there has been offered a solution that works fine for you
If You like solutions provided by anyone, feel free to add reputation using STAR *
When you say refresh, do you mean clear any data in the userform, or have the userform open?
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
i have a listbox on my userform. which one is showing data and need to refresh this list to see the updated records
thank you
Open your userform modeless and use next code to fill listbox.
Then in your eventcode use this.
Please Login or Register to view this content.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank You Bakerman2 for reply
i am using this code to fill my listbox
and want to populate data of Sheets("entry")
Please Login or Register to view this content.Please Login or Register to view this content.
Build your array in your Change-Event and pass it to the Userform ListBox.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks