Strikethrough a specified row

[fatalcore]

Hi friends,
Can somebody please help me how to strike through a particular row using vba code.

I have an excel sheet and I have 20 rows, I have created a user form and have created a combo box which populates the row number, can somebody please help me, how to strike through that row only when I click strikethrough after I select it in the combo box.
Thanks in advance,
best regards,
me.

[john456852]

what do u mean by "strikethrough"?
like in format?

[fatalcore]

Hi John,
yes, for example i select the row number 5 in the combox and click on strikethrough,
the value from Column A to Column I will be striked through.(Like manually what I do is rightclick on a cell Format cells>Font>Strikethrough)
Thanks in advance,
me

[john456852]

so it is Row(a) to whatever row u choose?

[fatalcore]

No, it is like I select row 5 then the values in row 5 from column A to Column I is striked through.
I have attached an example actually what I am trying to achieve.
thanks a ton
best regards,
me

[john456852]

i got it!(wait for dramatic effect)

Strikethrough.xlsmhere it is!

updated it!
(added option button)
Strikethrough.xlsmStrikethrough.xlsm

didn't u finish already?
with the "example file"? row 5 is strikethrough

click star icon if i helped.also mark as solved(don't forget),but u are a "forum contributor", so i guess u know that

[fatalcore]

Done John,
Thanks a ton. I just added +5 to this line and everything worked like a charm ! :D

Please Login or Register  to view this content.

Thank mate,
Best regards,
Me

[john456852]

you're welcome

glad to help