Macro to highlight a certain row

[p0c]

Before I go any further I must say I am certainly no expert with VB coding or advanced macros, but tend to get the job done by copying bits of code from various web pages.

I have a combo box linked to a list of 100 or so newspaper titles. As you know when a user selects a choice from a combo box it updates a number in a chosen cell. I need a macro to attach to this combo box so that when a choice is made it jumps to the row on another sheet in the workbook. The row would be the same as the number generated from the choice of the combo box.

I originally tried this code all the way up to 150, (which took ages to write!) but it doesnt work (??) after number 35 for some reason. Does anyone know an easier way of doing this?

Please Login or Register  to view this content.

This has already taken up more time than I have. Any help would be most appreciated.

Thanks

[abousetta]

Hello and welcome to the forum,

Without seeing your workbook, maye replace the whole Select case options with this line:'

Please Login or Register  to view this content.

If you could share a dummy workbook then we can give further advice.

Hope this helps.

abousetta

[p0c]

Thanks ever so much for your quick reply abousetta. That was exaclty the code I needed and seems to work much better than what I had entered. The reason it wasnt showing past row 35 is because I had a macro to automatically show the top row every time a sheet was opened and I completely forgot.

Your code is much better and will mean I wont have to keep updating it as the list grows.

Thanks ever so much!

[abousetta]

Glad I could help and thanks for marking the thread as Solved.

abousetta