MrExcel Message Board Archive


  • Color property doesn't set ANY color
  • Dave H.? Disabling Commandbar buttons/controls via VBA?
  • font in comments
  • Type Mismatch
  • ??? Userform and Macro code should work but it doesnt
  • msgbox list
  • Conditional sum gives a (runtime) FormulaArray error
  • Making graphs with macros on different worksheets
  • Help with school project please
  • printing backrounds
  • Userform and execution of macro
  • a macro that checks if there is a value in a cell
  • A few cells with 3 digits, I want 4 digits: 345 -> 0345
  • Proper code for Pasting Values
  • Compile Error - Can't find project or libraries
  • How to change size and location of Msgbox and Inputbox
  • Move File to Different Directory
  • Conceptual/Design Help required
  • Debug.print not working
  • IF...THEN...insert row
  • m2 after a sum equation
  • formula
  • I want CommandButton3 To Do What CommandButton2 Does
  • Activecontrol in a Multipage
  • I need for my charts to auto-update each month.
  • Comparing 2 columns of text
  • Help! I'm about to lose it!
  • Visual Basic Excel Find
  • Cancel exit event execution
  • Adding hours, minutes and seconds
  • Function key to input current time
  • Hiding columns when a particular cell is empty.
  • Gantt Chart
  • Warning message boxes
  • One more question...
  • Excel macro. how to fix a column so that it could only enter
  • Difference in months given two dates
  • Sorting IP Addresses
  • IF statement and "" syntax for leaving cells blank
  • Ending a Macro at a specified time
  • How do I set a function key
  • I want my lookup to say 0 if it can't find anything - help!
  • easy question - select and copy last row in spreadsheet
  • COUNTIFS AND MESSAGEBOXES... HELP!
  • csv file load
  • Deleting blank pages
  • compare to lists
  • COUNT "INTERIORCOLOR" CELLS
  • Charting
  • Check this Code For Me Please- Can't Figure out what's wrong
  • Warning signs on message boxes
  • elapsed times
  • Linking To Access Databases
  • Saving Excel files without Marcos
  • userform textbox data validation
  • Batch File
  • macros!!??
  • Search for a value then format a row
  • Toolbar Positioning
  • Novice Looking For Help
  • FORECAST function
  • Uprotecting VBA Project
  • Saveas macro
  • Can custom toolbar be non-global?
  • Macro by Reference
  • CountIf problems
  • Adding months to a date range
  • Please help?!
  • sql.request
  • merging duplicate information in a column
  • XP Macro Incompatibility
  • Time and date stamp on a worksheet
  • Hiding forms with a timed event
  • Formulas Do Not Work Automatically
  • Input data
  • Macro Question
  • Two functions in one cell
  • Rows
  • Can a Cell Formula run a Macro
  • Set Print Area Dynamically for all worksheets in workbook
  • can macro parse multiple excel files
  • Can I have a message pop up when a control gets the focus
  • Find and replace
  • WEIRD behavior w/ range.interior.color property
  • Input MessageBox / Msgbox to choose a location of a file
  • Mouse Pointer
  • Negative Percentages
  • Change font color in Excel footer
  • See through spreadsheets
  • nearest neighbour analysis
  • If row count is > 1 use subtotal else do not???
  • Automatic Links
  • Adding 1 month at a time to a date list
  • Autosum Textbox in Chart?
  • count empty cells
  • Questions, Questions
  • Using a cell to change the filename reference
  • can't get rid of leading space in cell
  • How do I insert a hyperlink for a worksheet in a workbook?
  • Excel Problem