allow the user to add or delete new categories (user-defined) to a data table (these would be the columns/column headings) on a main worksheet, allow the user to add or delete records (a row of a ...

The VBA project streamlined data transfer within Excel through a user-friendly form interface. Users could seamlessly copy and paste data as values, creating new Excel files or worksheets. The VBA ...

Say, that I have a User Form in VBA & Excel. I am prompting the user to input initials for a user or something. I want the initials to always be uppercase (ie. 'EDH' instead of 'edh'). Is there a way ...

I'm rapidly discovering that many of the things that I take for granted in Access VBA aren't so easy to do in VB6. Or perhaps they are and i just don't know.<P>Here's what I want to do in VB6: ...