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
The change worked perfect. Thank you so much!
On Apr 14, 3:09 am, "STDEV(i)" wrote:
> please try this vba code
>
> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
> If Target.Count = 1 Then
> If Target.Column = 3 Then
> Dim T As Integer
> T = Application.In
In Column C I have a format of h:mm:ss. How do I tell my inputbox when
the user enters a number such as 10, or 20 etc... that it should be
0:10:0, 0:20:0, etc... Thanks so much for any help at all.
--
--
Some importan
I need to be able to insert text into a cell using the “inputbox”
function linked to a button. The macro below allows me to input the
text, but getting it to go somewhere eludes me. I realize that
"Copy.Name" doesn't work but how do i direct the entered text to a
cell? Suggestions appreciated.
T
