Hello and thanks for reading, I use two conditional format formulas in the same column to bold the highest and lowest values starting in row 6 to row 38 as...

Hi, I would like to make a vbQuote constant, like: Const vbQuote As String = Chr(34) ....so that I can use vbQuote when I need to insert a " in a string,...

all, I have a ip address in cell J5 on sheet1 called variables. How do I make that particular cell to be active so that whenever I click on that button it...

Hello all, I am new to the forum and the world of programming via VBA in excel. The only programming knowledge I have is QBasic from high school -- i.e. i do...

It is possible to avoid 'compile Error' when calling another macro and that macro doesn't exists, by using Application.Run. So, instead of using Call...

I have a spreadsheet with some ip addresses in it that I would link to issue a "ping" command for, parse the results and put the results in a different...

I have been relying heavily on global variables to return a value (or values) from any Userform in my program. Is this the only way to return a value from...

Hey Everyone, Here's what I'm trying to do: If a cell value from one sheet equals another sheet name, I want to enter a value from a cell adjacent to the...

In vba, is there a way to exercise/engage the validation already defined in a cell?? I have cells that have defined data rules but I seem to be able to set...

Hello Sir, I create button on sheet1 and hyperlink this button to open sheet2. after that i hide sheet2 but when i hide sheet2 link nor work. i want to button...

Hallo I am back to ask for more help to You. First table: A,B,C are input data D = summ of value from 2nd table E= C-D F= input data A B C D E F

Is there a quick way to detect if the user double clicks a specified range? I'm currently dealing with the "Target" parameter of the...

The following two commands achieve the same result: 1) Sheet13.Cells(7, 6).Value = 1 or 2) Sheet13.Range("F7").Value = 1 If these two...

What is a quick and fast way to delete a row that is double clicked by the user? I know I must handle the Worksheet_BeforeDoubleClick() function and the...

Code is in sheet "Summary" module. This works fine as far as adding a number of sheet and naming them from the list C9:Cn on sheet named "Summary". There are...

Hello, I need to use vlookup in different way. As it is known well, vlookup finds a common key and insert a described cell for the related match. However, I...

I have an input box that searches column 8. Ok, no problem. It pulls the data (copies it) and pastes it. Except that it's pasting some of the wrong...

I know how to use validation in cells and I know how to build basic forms. (lol - aren't I smart). What's the best way to validate data entered from a form. ...

Hi All, I want to plot a polyline in excel using the XY Coordinates. I tried using the following Sub plinee() For i= 1 to 10 myshape(i,...

The following code generates an error in Line 5 Sheets("APR").Select Rows("9:9").Select Selection.Insert Shift:=xlDown,...