Check Box with a tint of E-street!

[Matt_Chelmsford]

[/URL][/IMG]

Afternoon all,

By way of macro attached to a check box, what I want to do is be able to tick a box and then a concatenation of the resources and the mode (Day) appear in the list starting in A34.</SPAN>

Likewise, if a box is un-ticked, I would like the resource & mode taken away from the list
</SPAN>
On the attached spread sheet, I have given examples.
</SPAN>
I have a total at the bottom of the list that I would like to cater for any insertions. Potentially (very unlikely), this list could end up being 98 lines and I would like the list to be able to grow/shrink accordingly.
</SPAN>
I will appreciate any help given!
</SPAN>
Kind Regards</SPAN>

Matthew </SPAN>

 

[Andrew Poulsom]

What have you tried? Where are your CheckBoxes from? Rather than posting an image use the HTMLMaker here to post a snapshot of your worksheet:

https://skydrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

 

[Matt_Chelmsford]

What have you tried? Where are your CheckBoxes from? Rather than posting an image use the HTMLMaker here to post a snapshot of your worksheet:

https://skydrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Thanks Andrew,

Will this work for 2010?

The check boxes and from developer and cell linked to the cells that the check boxes are in.

Kind Regards

Matthew

 

[Andrew Poulsom]

The HTMLMaker works in Excel 2010. Are your Checkboxes Form controls or ActiveX controls? The former would be easier to work with.

 

[Matt_Chelmsford]

Form controls but am happy to change them!

 

[Matt_Chelmsford]

I am struggling with this HTML Maker, I can see it on my ribbon, I go to add ins/Mrexcelhtml/I go to generate html (after setting default options) but nothing seems to happen.

The address info still shows it as an xls file?

 

[Andrew Poulsom]

Your data is copied to the clipboard. Start a reply on the Board and press Ctrl-v. Don't worry what it looks like, just click Post.

 

[Matt_Chelmsford]

Excel 2010
	F	G	H	I	J
25
Inputs (2)

Cell Formulas
Range	Formula
C9	=-((90-(B9-B4))/90)

 

[Matt_Chelmsford]

Excel 2010
	F	G	H	I	J
25
Inputs (2)

Cell Formulas
Range	Formula
C9	=-((90-(B9-B4))/90)
C14	=ABS((USDGBP-1.6)/1.6)
C15	=ABS((EURGBP-1.2)/1.2)
C16	=ABS((EURUSD-1.333333333)/1.3333333)
C22	=ABS((Fuel-1100)/1100)
C27	=IF(B27=B38,"a","r")
C34	=IF(B34=D34,"a","r")
C35	=IF(B35=D35,"a","r")
C36	=IF(B36=D36,"a","r")
C37	=IF(B37=D37,"a","r")
C38	=IF(B38=D38,"a","r")
E32	=IF(F9<>"",F9,"")
E38	=IF(E32<>"",SUM(E34:E37),"")
F32	=IF(F10<>"",F10,"")
F38	=IF(F32<>"",SUM(F34:F37),"")
G32	=IF(F11<>"",F11,"")
G38	=IF(G32<>"",SUM(G34:G37),"")
H32	=IF(F12<>"",F12,"")
H38	=IF(H32<>"",SUM(H34:H37),"")
I32	=IF(F13<>"",F13,"")
I38	=IF(I32<>"",SUM(I34:I37),"")
J32	=IF(F14<>"",F14,"")
J38	=IF(J32<>"",SUM(J34:J37),"")
K32	=IF(F15<>"",F15,"")
K38	=IF(K32<>"",SUM(K34:K37),"")
L32	=IF(F16<>"",F16,"")
L38	=IF(L32<>"",SUM(L34:L37),"")
M32	=IF(F17<>"",F17,"")
M38	=IF(M32<>"",SUM(M34:M37),"")
N32	=IF(F18<>"",F18,"")
N38	=IF(N32<>"",SUM(N34:N37),"")
O32	=IF(F19<>"",F19,"")
O38	=IF(O32<>"",SUM(O34:O37),"")
P32	=IF(F20<>"",F20,"")
P38	=IF(P32<>"",SUM(P34:P37),"")
Q32	=IF(F21<>"",F21,"")
Q38	=IF(Q32<>"",SUM(Q34:Q37),"")
R32	=IF(F22<>"",F22,"")
R38	=IF(R32<>"",SUM(R34:R37),"")
S32	=IF(F23<>"",F23,"")
S38	=IF(S32<>"",SUM(S34:S37),"")
T32	=IF(F24<>"",F24,"")
T38	=IF(T32<>"",SUM(T34:T37),"")
U32	=IF(F25<>"",F25,"")
U38	=IF(U32<>"",SUM(U34:U37),"")
V32	=IF(F26<>"",F26,"")
V38	=IF(V32<>"",SUM(V34:V37),"")
W32	=IF(F27<>"",F27,"")
W38	=IF(W32<>"",SUM(W34:W37),"")
X32	=IF(F28<>"",F28,"")
X38	=IF(X32<>"",SUM(X34:X37),"")
D34	=SUM(E34:W34)
D35	=SUM(E35:W35)
D36	=SUM(E36:W36)
D37	=SUM(E37:W37)
D38	=SUM(D34:D37)
A35	=IF(O9=TRUE,L9&" "&O4,"")
A36	=IF(P9=TRUE,L9&" "&P4,"")
B38	=SUM(B34:B37)

Named Ranges
Name	Refers To	Cells
'Inputs (2)'!EURGBP	='Inputs (2)'!$B$15
'Inputs (2)'!EURUSD	='Inputs (2)'!$B$16
'Inputs (2)'!Fuel	='Inputs (2)'!$B$22
'Inputs (2)'!USDGBP	='Inputs (2)'!$B$14

 

[Andrew Poulsom]

Select a bigger range and choose the option to exlude formulas.