Highlight cell

[Sam.K]

Hi, it is possible to do it.i need macro code that when i selected some cell in worksheet and then click the macro button. it will be highlight that cell with yellow color.
eg. cell b2 is seleted ,after click macro button. cell b2 will be change color to the yellow color.
thank.

[mudraker]

For all selected cells

Please Login or Register  to view this content.

For only the active cell

Please Login or Register  to view this content.

The above code you could have gor by recoeding a macro whist changing the cell colour

[Sam.K]

Thank for your help.
but please apply the code it for used with the text box or not.
let the textbox ask for the cell to select ,then when i key in textbox with the cell b2 is select,then it highligh the yellow color.

[mudraker]

It would help if you specified all the specifics in your 1st post instead of changing the specifactions of what you want the code to do after you get a reply.

Please Login or Register  to view this content.

[Sam.K]

Hi,thank your second code is very useful code.
i am a beginner ,i am trying to learn more.can you help me more for this new question?
eg. if i need to highligh the cell id ,after i input the number id in the inputbox. it will be highligh that row of id found which highligh only with column a,b,c (column A is item no.,column B is ID no., column c is the name).plese see my attach file to make more understand.
i hope your help ,please.
thank.

[royUK]

Why not just use the inputbox to select all the cells to higlight?

[Sam.K]

Thank,Roy UK
I am understand. but I try to learn more the code apply use for the case of..
if i key in id no ,it found that id then will be highligh the cell of item ,id,name.
my eg. you will see when i key in id no. 112 in the inputbox,then it found in row2,it will be highligh the cell of item2,id 112,name mr.b.
that is possible can do. i need that code to know.
Thank for your help