allenmattson / vba

Code Blocks relating to everything VBA

VBA class, module, and form project codes

Excel, Outlook, Access, Powerpoint

Large repository of folders containing .xlsm workbooks and code modules that the workbook contains

These VBA code examples come from a personal collection that I reference frequently.

Extensive and in depth VBA code blocks for filesystems and other applications

Use the folders as a guide and modify the code to suit your needs.

vba's Issues

Question about where to look

Hi, does anyone know if there is a module in here that could be used to help make an appointment tracker? My gf works at a nail salon and they want to keep track of appointments using Excel. So they need to be able to input certain criteria such as name, date, phone number, etc and then be able to visualize the appointments for a certain date range.

I figured I'd ask to see if I can get a bit of a head start instead of randomly looking through it.

Thanks, Thomas Reid

Getting error while opening xlsm files

Hi Allen,

I am writing this as i am facing issue while opening the xlsm files. Below error is occuring.

"The File is corrupted and cannot be opened"

Please help me with this.

Thanks and Regards

VBA Blanks removal issue

Hello All,

I have written a VBA code to remove blanks in the particular column. But it removing all the blanks and unfortunately its excluding a blank and not removing that blank row. Can you please help me out where i went wrong.

Help me with the code to remove blanks in a specific column.

Thanks for your response