bearasaurass
New Member
- Joined
- Sep 16, 2010
- Messages
- 1
I have a userform I am working on that basically acts as an advanced filter. I am barely versed in vba so I put my mild skills to use by editing a template. One of the functionalities that it is missing is that I can't seem to get the filtered items that show up in the listbox to be clickable links.
The data is for work. It is for SAP transactions and profiles. Once working, we will be able to filter by transactions, profiles, access controls, and profile type. All of this is working at the time. The access controls are quasi-lengthy so I would prefer a link in each cell that when clicked, moves the user to a different worksheet to a specific cell containing the access controls for that particular profile/transaction/type.
So, in short, I want clickable hyperlinks that show up in the userforms listbox that redirect users to a specific worksheet/cell within the same workbook.
The data is for work. It is for SAP transactions and profiles. Once working, we will be able to filter by transactions, profiles, access controls, and profile type. All of this is working at the time. The access controls are quasi-lengthy so I would prefer a link in each cell that when clicked, moves the user to a different worksheet to a specific cell containing the access controls for that particular profile/transaction/type.
So, in short, I want clickable hyperlinks that show up in the userforms listbox that redirect users to a specific worksheet/cell within the same workbook.
