Cell contents to Check Box Value

[IBnew2VBA]

I am creating a workbook and userform where I am giving the user to change information that has been typed in. I am able to pull up all the information. 1 of the fields is a supported field which relates out to what type of product it supports when it writes to the spreadsheet it is put it like this

farm, barn, school, warehouse (Can go to 7 different types of just 1).

I have it extracting to show that
T1 = Farm
T2 = Barn
T3 = school
T4 - warehose
etc. T1,etc = a variable

The problem when is when the user clicks on the "supported" cell on the user form it pull up 7 check boxes and they can select which 1 it supports. What I want to do is have those check boxes that it currently had saved to be already checked. Is their an easy way of doing that?
The checkboxes on the 2nd (userform called supported) are
checkbox 1, checkbox2,,,checkbox7

 

[SkipVought]

Hi,

So you have a UserForm, in order that the user can select a checkbox and then the selected value is put on the sheet?

I see some problems.

1. Checkboxes are not mutually exclusive. The user can select NO checkbox or MULTIPLE checkboxes. This is what Option Buttons are for.

2. But why the UserForm to begin with? Put a Data > Validation --LIST (drop down)[/b] so the user can directly select the value to go in a cell in the column.

No need for VBA, unless I have totally misunderstood your intent.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[IBnew2VBA]

That is just 1 part of an extensive project that I have for it. there are about 11 other different parts to it that do different things. Look up training docs, print documents, etc. This is just a section of what I am doing.

as it is on this I have the code written to where a CHECK Box must be checked or it will not proceed. The checkbox in this instance is used for finding materials that are used in a multitude of different products. Sort of like a Bill of Materials but not as complicated.

Never thought of using the option buttons to be honest been using check boxes all along. I can go back and redo if it is easier

 

[PHV]

redo if it is easier
I'd not say easier but safer.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

"finding materials that are used in a multitude of different products"

If you are using a FIXED number of controls (check boxes or option buttons) for "a multitude of different products," that is not a very good design, since product lines are somewhat volatile. When such volatile lists are assigned to controls for user selection, a combobox, or listbox are much better choices.


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}