I want to run a VBA macro which will fetch some data(few fixed no of columns and varied no of rows) from another worksheet. Need to display the same on a user form. Please anyone guide can this be done in excel.
The form will get activated when any event(right click etc ) is done in a certain cell in the separate worksheet. Once data is seen by the user he can close the form and click on another cell for a different set of data.
Hi,
Do you mean that you want list or combo boxes on the Userform to be populated with rows and columns of data?
How many columns and how many rows?
Must admit it seems a bit of overkill but upload your workbook and explain which sheet's data should populate the userform and how and where on the user form you expect to see it.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks