Hi everyone,
I have two sheets, the first is "Form" & the second is "Tracking". The "Form" sheet contains one button that, when clicked, brings up a userform. The userform has 11 checkboxes & two buttons ("View Next" & "View Previous"). The "Tracking" sheet has 11 columns (A - K), which will contain either "True" or "False".
I need the checkboxes in the userform to pull the values from the "Tracking" sheet. For example, the "Tracking" sheet has the following information listed:
A1 = True
B1 = True
C1 = True
D1 = False
E1 = True
F1 = False
G1 = False
H1 = True
I1 = False
J1 = True
K1 = True
Therefore, the checkboxes in the userform should be displayed as :
01 = Checked
02 = Checked
03 = Checked
04 = Empty
05 = Checked
06 = Empty
07 = Empty
08 = Checked
09 = Empty
10 = Checked
11 = Checked
"True" = a ticked checkbox & "False" = an empty checkbox.
What I also need, is that when the "View Next" button is clicked in the userform, the checkboxes change according to the new data. For example, when the userform is opened, it should default to the first row of data in the "Tracking" sheet, but when the "View Next" button is clicked, it should read from the second row of data, & so forth. The "View Previous" button should do the reverse, basically go from the second row to the first, or the fifth row to the fourth, & so on.
I've attached an example of my worksheet to this post. Please note that this example is a minor section taken out of a much larger workbook that I'm working on, however I can't post everything due to having company (that I work for) information in the full copy; thus, I do apologize if the example worksheet is a bit rough.
Any ideas
Thanks,
- I Love Lagar -
Bookmarks