Spin Button on a VBA Form Controlled through/by a range.

UserPaul

New Member
Joined
Apr 4, 2018
Messages
1
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
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,224,818
Messages
6,181,151
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top