1. ACommandLineKindaGuy

    Excel Ribbon: Change a control's default screentip/supertip

    Some built-in controls (eg, idMso="FileSaveAs") allows customization of the screentip and supertip properties. Others, such as idMso="CellFillColorPicker" apparently do not. Is there a way to override these properties? TIA John
  2. A

    Replace or override sub code

    Hi! so I'm very new with Vba in excel. i have a code that sends specific data (from excel files) to an access database. i wrote a code that loops through several hundred files and sends this information. The problem is to manually update these files, it is sent with a button. I need to override...
  3. C

    VBA Help with copying from sheet to Sheet with Validating list

    So I have hit a brick wall with my project I am working on in Excel. Here is my scenario for example I have a worksheet with a list of 17 questions with answers based on a validation list. My client would like to have the answers copied over to Sheet2 which is not a big deal however they want...
  4. kelly mort

    Delete file in a folder with vba or override with new file

    Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim backupfolder As String backupfolder = "C:\BackupFile\" ThisWorkbook.SaveCopyAs Filename:=backupfolder & ThisWorkbook.Name End Sub Hi, The above code is what I am using to create a backup of my...
  5. P

    Form Textbox to only allow certain values

    Hey, I have a textbox on my form that manually has values entered based on a Truth Table however, I want to be able to override these fixed values and then input my own if applicable. I have an override button that activates the manual entry into these boxes however, I'm having trouble on...
  6. K

    VBA to override typed workbook name on save

    Is there a way to write a VBA code in a sheet that will override any name a user enters when a workbook is saved? I want the sheet to pull the name from a cell instead of accepting the name they type in because they never name the file properly.
  7. S

    Delete Rows

    Greetings, I have been looking through the forums for an example, but i can't find exactly what I am looking for. I am looking for VBA to run through my sheet and remove rows that contain a certain keyword (override) in a certain column (F). The thing that is tripping me up is that the...
  8. sharky12345

    Add extra COUNITF to formula

    I've got this formula that I need to expand if someone can help; I need it to check O2:O42 and if C2 is found I need it to show "Abstracted" - this should override the "YES" or "NO" part if possible.

    How to Override Conditional Formats

    I hope I can explain this situation in an understandable way. I'm using Excel 2007. For several columns I have conditional formatting (fill cell with white) if it contains the high or low value within a range in that column. There is a row for each date (day) of the year. A 1st-time (&...
  10. M

    Overriding Macros

    Hi, I currently have a simple macro (see below) that requires users to input values in specific cells, otherwise it will not print or save. However, I need to be able to leave the values blank before saving and sending to the user. Any suggestions? I want to be able to save with blank cells...
  11. N

    VBA - override autofilter warning message

    Good evening guys, Just a quick (I hope) question: I'm creating a tool to use at work. It will essentially perform an autofilter operation. The thing is that I want the results to be only 5, so that's the limit I have in my destination range and, if by any inexplicable reason, someone search...
  12. H

    Warning when overrides PDF

    Hi, I have the following code for saving as PDF: Private Sub LagrePDF_Click() Application.DisplayAlerts = True If Sheets("Lister").Range("BQ3").Value = "x" Then If Sheets("Rapport").Range("AE6").Value = "" Then Call PdfGnrBnr Else: Call PdfGnrBnrFnr End If Else...
  13. Jaafar Tribak

    Overriding Excel Methods and Properties (VTable hacking)

    Hi all, I have been reading on the layout of COM objects and Virtual Tables and I have managed to hack Excel Methods and Properties .. It's surprisingly easier than I had thought but just as I was getting excited about this idea and it's enormous potential for adding new functionality to Excel...
  14. I

    Customize ALL 6 of Excel DEFAULT currency Options in currency drop down menu

    I have seen a lot of posts about how to establish the default currency option in excel, however I want to define all 6 of the first currencies in the currency drop down menu. With the defaut region set to the US, the five currencies listed are: $ English (United States) £ English (United...
  15. F

    Pop up question if data already exists

    Hi I have a excel sheet that users use to input data in to table. The following data that user has to input is: Column B= Name C= Quarter D= Year etc.... What I want is when user puts in a name, quarter and year and more information excel checks if following data(Name,Quarter and Year)...
  16. dukeofscouts

    Stopping Message boxes

    I have to macros that I use very often, both of these codes cause excel to display message boxes to be displayed. One is from a SAVE command, the other from a copy/paste command structure. I presume there is a way to turn these messages off, or write into the VBA to trick excel into thinking...
  17. G

    Override conditional formatting

    Hi All, My first post here, I am a bit of a novice at excel and a complete novice at VB and VBA so be patient with me. It seems a relatively simple problem, but I can't seem to find an answer. I am using Excel 2002 on XP with SP3. I have a large spreadsheet that for ease of reading I have...
  18. R

    Rank with Override

    Hi. I have a list of projects that each get assigned a rank based on different criteria. I then allow the user to override the assigned ranks if needed. The override column will only have values filled in where an override takes place. I then want to re-rank all of the projects accounting...

Some videos you may like

This Week's Hot Topics