I have a spreadsheet that contains a list of Descriptions of User Names - obviously password protected itself.
I have a range of names of "Descriptions" in the column A1 to A20. This range I have called "MyUserNames" and might contain "Amazon - Paul" or "Amazon - Liza".
In the corresponding columns to each value in "MyUserNames" are Actual Internet Addresses, User Name, Password & Comment.
In a VBA Form, I would like to generate 5 Text Boxes containing the above data with a Spin Button controlling the value in Text Box 1 which should be the Description.
As an example the form should look like:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Descriptions eg Amazon - Paul
[/TD]
[/TR]
[TR]
[TD]Internet Address eg www.Amazon.co.uk
[/TD]
[/TR]
[TR]
[TD]User Name eg Fred
[/TD]
[/TR]
[TR]
[TD]Password eg GoFred
[/TD]
[/TR]
[TR]
[TD]Comment eg This is UK version of Amazon
[/TD]
[/TR]
</tbody>[/TABLE]
With a vertical Spin Button controlling "Descriptions" which are listed in the range "MyUserNames".
What code do I need to write to access the range values. I am used to using spin buttons directly on a worksheet but my ability to write the necessary VBA code is limited in the occasion.
I hope that the explanation of my problem is clear enough.
I am using Office 2010 on a PC operating Windows 10. I program via VBA 7.
Thank you for your anticipated help.
UserPaul
I have a range of names of "Descriptions" in the column A1 to A20. This range I have called "MyUserNames" and might contain "Amazon - Paul" or "Amazon - Liza".
In the corresponding columns to each value in "MyUserNames" are Actual Internet Addresses, User Name, Password & Comment.
In a VBA Form, I would like to generate 5 Text Boxes containing the above data with a Spin Button controlling the value in Text Box 1 which should be the Description.
As an example the form should look like:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Descriptions eg Amazon - Paul
[/TD]
[/TR]
[TR]
[TD]Internet Address eg www.Amazon.co.uk
[/TD]
[/TR]
[TR]
[TD]User Name eg Fred
[/TD]
[/TR]
[TR]
[TD]Password eg GoFred
[/TD]
[/TR]
[TR]
[TD]Comment eg This is UK version of Amazon
[/TD]
[/TR]
</tbody>[/TABLE]
With a vertical Spin Button controlling "Descriptions" which are listed in the range "MyUserNames".
What code do I need to write to access the range values. I am used to using spin buttons directly on a worksheet but my ability to write the necessary VBA code is limited in the occasion.
I hope that the explanation of my problem is clear enough.
I am using Office 2010 on a PC operating Windows 10. I program via VBA 7.
Thank you for your anticipated help.
UserPaul