Tags » Vba

Simple Toggle to Change View

Here’s a simple bit of code which combined with a toggle button allows the user to change the view of a worksheet. 349 more words


Setting Up a Debug Environment for VBA

VBA supports Conditional Compilation. Most often this is used to switch between different methods based on whether the installed version of Office is 32 or 64 bit, but it can also be used to set up a kind of debugging environment. 605 more words


Exporting Parts Lists from Drawings to Excel With Thumbnails in VBA

So, I cruise around the Inventor User Group on LinkedIn from time to time, and yesterday a post caught my eye. An inventor user asked if it was possible to save BOMs to Excel with thumbnails. 349 more words


UCase not being recognised in VBA

Getting a code compile error on UCase() / UCase$() in VBA.
Error Message: “Compile error: can’t find project or library”.
What library is required to be add through references to recognize this?
35 more words


UK eBay & PayPal

So…..here we are, it’s taken a long time to get to this stage to be blogging online and offering a service that no one else on the internet currently can offer. 112 more words

EBay Suspension Solutions

Numeric Variable Types

I can’t recall now where I got this table from to explain the differences between different numeric variables. It certainly helped me understand when to use Integer or when to use Long or Double, etc… 144 more words


Primer on Visual Basic

Gaining a moderate understanding of Visual Basic is an important goal for this course. ¬†However, I’ve not assigned a textbook to work from.¬†There are many, many books on the subject and Amazon would be delighted to… 191 more words