General Topics in VBA Tips - All Tips (38 tips)
- Set the Background Color according to the date using VBA in Microsoft Excel
- Change font color based on Date using VBA in Microsoft Excel
- Set background color depending on value verification using VBA in Microsoft Excel
- Set up yellow background color for header in an AutoFilter table using VBA in Microsoft Excel
- Display message if column total is exceeded using VBA in Microsoft Excel
- Display a record with a right mouse click using VBA in Microsoft Excel
- Replace value from validation list with a number using VBA in Microsoft Excel
- Prevent entry of invalid values using VBA in Microsoft Excel
- Merge cells without loosing values using VBA in Microsoft Excel
- Validation list without empty cells using VBA in Microsoft Excel
- Create worksheets from a list of names using VBA in Microsoft Excel
- Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
- Generate total for dynamic area using VBA in Microsoft Excel
- Search, enter, and delete values using VBA in Microsoft Excel
- Display AutoFilter criteria after filtering using VBA in Microsoft Excel
- Turn off warning messages using VBA in Microsoft Excel
- Determine the screen size using VBA in Microsoft Excel
- Restore the position in the window using VBA in Microsoft Excel
- Turn off warning messages using VBA in Microsoft Excel
- Determine the type of operating system using VBA in Microsoft Excel
- Playing MIDI-files using VBA in Microsoft Excel
- Playing WAV-files using VBA in Microsoft Excel
- Playing sound notes using VBA in Microsoft Excel
- Basic information about OLE automation using VBA in Microsoft Excel
- Convert negative values treated as text using VBA in Microsoft Excel
- Insert pictures using VBA in Microsoft Excel
- Private Profile Strings using INI-files using VBA in Microsoft Excel
- Private Profile Strings using Words System.PrivateProfileString using VBA in Microsoft Excel
- Private Profile Strings using the Registry using VBA in Microsoft Excel
- Restore the VBE windows to their default positions using VBA in Microsoft Excel
- Array variables using VBA in Microsoft Excel
- Display all installed fonts (Word) using VBA in Microsoft Excel
- Display all installed fonts (Excel) using VBA in Microsoft Excel
- Open and close the CD-ROM tray using VBA in Microsoft Excel
- Change the cursor appearance to hourglass using VBA in Microsoft Excel
- Eliminate screen flashing while running a macro using VBA in in Microsoft Excel
- Hide an excel sheet without the option of unhiding it using VBA in Microsoft Excel
- Using the Macro Recorder in Microsoft Excel
»Click here to submit a tip to General Topics in VBA tips
