macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Inputbox to locate and highlight cell
You would need to use Match to find the locationof thecell. Than you would use
Cell(?,?).format.interior.color= to highlight the cell. Lastly use
ScrollIntoView (I think it is called that) to make the cell sit
You would need to use Match to find the locationof thecell. Than you would
use Cell(?,?).format.interior.color= to highlight the cell. Lastly use
ScrollIntoView (I think it is called that) to make the cell sit in the
visible area.
On 18 February 2012 11:29, Bob wrote:
> I'm trying to create an
I'm trying to create an inventory tracking system to pinpoint a
specific
location(a simple one) which, when the part number is entered into the
Inputbox,
Excel will go to, select and highlight that cell where the part number
is
located. I'm familiar with VBA just don't know the code, also using
exc
