8 Answered Questions for the topic vba

08/17/19

Running VBA Macro in AutoCAD?
I'm making a .bundle folder for the plugins I've programmed for AutoCAD. At the root of the folder is my PackageContents.xml bundle where all of my Lisp plugins are autoloaded. Since .dvb is not a... more
Follows • 1
Expert Answers •1

08/04/19

Copy Excel worksheet and maintain relative cell reference in formulas?
Another copy problem in Excel: How can I copy a Worksheet from WorkbookA.xlsx into WorkbookB.xlsx without the copied Worksheet still referencing WorkbookA.xlsx e.g. the formula `=B!23` becomes... more
Follows • 2
Expert Answers •1

08/01/19

How to check the given point is in selected line or not?
Say I have a line, and then I am randomly given a point. I want to check whether the given point is on the line or not? I am using autocad with vba
Follows • 1
Expert Answers •1

07/12/19

Deleting Two Columns Simultaneously?
The following code deletes Column J only: If Application.WorksheetFunction.Sum(Range("J:J").SpecialCells(xlCellTypeVisible)) _ =... more
Follows • 1
Expert Answers •1

07/05/19

VBA If <any of these> = <value>?
I'm fairly new to VBA, and I can't find an easy way to test if any of the specified variables equal a specified value. The below seems to work, but is there an easier way to do it? If variable1 =... more
Follows • 1
Expert Answers •1

05/19/19

Excel VBA Code to pull SSRS data as a dataset?
I can’t seem to find a solution for my problem no matter how much I Google. (Please excuse my verbosity in the following explanation) My process is that I have to go to the SSRS web page, run my... more
Follows • 1
Expert Answers •1

05/03/19

Click a button and the button would be unable to be clicked until reset?
Is there a way I could be able to click a Button and then once the button has been clicked it would be Unable to be clicked until the Form reset itself. Say... Enabling Auto-Save and can't be... more
Follows • 1
Expert Answers •1

03/19/19

VBA number formatting?
I am writing a macro package to format numbers in accounting format so that I don't have to click "alt - h - fm" every time I want to make a number accounting format (which my job requires). I have... more
Follows • 1
Expert Answers •2

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.