Search results

What has you defined in the data validation rule. If the entry is only for number between 1 to 100 Allow = Whole Number Data = Between Minimum = 1 Maximum = 100 And then define the Error alert. Everytime the user inputs a number which is not in the limit; the Popup will come on the...

try this free addin for older versions of excel http://sourceforge.net/projects/sparklinesforxl/ ~Vijay

bfraser, This type of error appears when a Excel 2007 file has been manually renamed as .XLS and you try to open. Excel 2007 = XLSX < Excel 2003 = XLS HTH ~Vijay

Ramnath, How many records are present in the excel sheet that you need to update in the access database. Are you searching for a specific account number in the access database and then update as necessary? Also..... this line seems to be incorrect Sheet1.Range("D2") & ")" You can loop...

Dear Arshad, As stated earlier; there is a Class module which creates the Timer and allow you to use. Yes, it is in the VBA code. ~Vijay

Try this.. in the data validation list =OFFSET($A$2,0,0,MATCH(2,1/(1-ISBLANK($A$2:$A$65536)))) ~Vijay

Jagadeesh, You can create another sheet called "Email" and then use this to send out emails accordingly. If you have a file already setup and just need the VBA code for doing this; please mail the file to me at sharma.vijay1-at-gmail.com And i will put in the VBA code for this. Also...

Here you go... Sub SaveFiles() Dim Retval As Variant With Application Retval = .GetSaveAsFilename(, fileFilter:="Text Files (*.txt), *.txt, Excel 97-2003 (*.xls),*.xls, Excel 2007 (*.xlsx),*.xlsx") If Retval <> False Then ThisWorkbook.SaveAs Retval End If End With End...

Sub DeleteARow() Dim rRange As Long On Error Resume Next Application.DisplayAlerts = False rRange = InputBox(Prompt:="Enter row number to delete (must be greater than 23). Once deleted, it can't be undone.", _ Title:="ENTER ROW NUMBER", Default:="24") On Error GoTo 0...

Not sure if this post is still needing an answer... but if someone else may benefit... the below code is the answer Sub DeleteARow() Dim rRange As Long On Error Resume Next Application.DisplayAlerts = False rRange = InputBox(Prompt:="Enter row number to delete (must be greater than...

Aarthi, I have tried to replicate what you have suggested above and the formatting still works. Here is what i did. A B C 1 04:30 05:20 =sum(A1,B1) 2 00:00 00:00 =sum(a2,b2) then i applied the cell format to C1:C2 Is this what you need? ~Vijay

John, We would need to write VBA code to check the below Ask / display the user a color palette to chose the Original Color Ask if this is for the whole sheet OR for a specific Range then search for the color using the below Application.FindFormat.Borders(xlEdgeRight).Color...

Try what Hui has suggested and it will work as breeze... 1. Select your cells where this needs to be applied 2. Press CTRL+F1 - OR - Right click and select Format Cells 3. Click on the Number Tab 4. Click on Custom 5. on the right hand side; under the Type BOX... 6. put this h:mm:ss;; 7...

John, If the workbook has been created in Excel 2003; we can easily modify the Default Color Palette to accomplish this. Open the workbook Go to Tools... Options... and then Click on the Color Tab Click on the color that you wish to change and then click on Modify. Now select the new...

Aarthi, You could use Conditional Formatting to accomplish this. For cells having value Less Than or equal to 0, format as White Text ~Vijay

aarthi, could you post an example of what is current in the cell and what should be hidden ~Vijay

John, Just 1 more thing to add to what Fred has suggested above... after you have selected the new color You will need to apply this to the relevant sections of the Table by clicking the relevate buttons for the table borders. However; my guess on this topic was you were looking for an...

Dear Guity, The code is meant to move the object to the Top and Left positions that are defined by the end user; so if that is working fine I do not see any issues. I was not able to follow your comment "the shape moves to the corner over those sales" Guess, the object is moving at a...

Dear Fred, I am available for providing lessons on VBA, if required. Dear Chandoo and Hui, Please consider this request as my candidature for being a Faculty / Guest Faculty if you decide to lauch the program. ~Vijay

John, Please see the full code below {code} Sub List_Files() Dim f As Object, fso As Object Dim folder As String Dim wb As Workbook, ws As Worksheet Set wb = ActiveWorkbook Set ws = ActiveSheet Set fso = CreateObject("Scripting.FileSystemObject") With...

John, Accepted and online on gotomeeting... Thanks ~Vijay

Great... Can you please set a gotomeeting and send me the invite on sharma.vijay1-at-gmail.com I will join in ~Vijay

John, Do you have teamviewer installed on your system, we can have a remote session where i can check and advice on what is happening. I am also on FB.... http://www.facebook.com/profile.php?id=643050427 ~Vijay

You have 2 requirements here. 1. To create a data entry form to capture the input. 2. To have another form which displays the data that have been entered. Are you 1. Using a database to store the data / or using excel as your database How to create a Form. In excel (2003). go to...

Guity, My office firewall does not allow to download the file from Skydrive; and the mirror zip at chandoo is broken. if possible please email the same at sharma.vijay1-at-gmail.com ~Vijay