VBA & MacrosAutomation
← All topics
Automation

VBA & Macros

Automating Excel with VBA, events and the object model.

16this week
66last 30 days
7sources
Most activeMrExcel Message Board 40Stack Overflow — [vba] 10r/excel 8Planet Python 3Real Python 3
Weekly VBA & Macros briefing

The few items worth your time, every Tuesday. Nothing else.

Free. One email a week. Unsubscribe in one click. · RSS

Latest in VBA & Macros

07

Excel vba selenium problems opening port [duplicate]

Since yesterday, I’ve been having problems with Excel VBA when using Selenium to open a website. I’m getting the following error: The driver failed to open the listening port 127.0.0.1:xxxx within 10 seconds I’ve…

Q&A · Stack Overflow — [vba] ·
09

Macro wont run

I just had a new 1TB hard drive installed and now found that my personally written macros won't execute. I created buttons and assigned macros to the buttons and placed them in Quick Access Toolbar. All my macros are…

Q&A Formulas & Functions · MrExcel Message Board ·
10

VBA msg pop-up based upon time entries

Good day, I'd like a msg pop-up prompt that will indicate if the name group (on my mini sheet there are 8 group names, can be more or can be less at times) associated with/from Column C with a duplicate time listed for…

Q&A Formulas & Functions · MrExcel Message Board ·
12

Viewing formatted Text in a Userform

Is it Possible to view Formatted Text in a Userform ? Would like to display a Cell which has Both bold and regular text along with different font colors and size. Could it be accomplish by reading in a text document?…

Q&A Formulas & Functions · MrExcel Message Board ·
15

How import specific sheets from specific files

Hi, I have file calls import and contains sheet Home to running the macro in cell A2 contains file name and B2 contains sheet name all of files will be xls,xlsm, csv,xlsx and will be existed in "D:\DATAX" the files are…

Q&A Formulas & Functions · MrExcel Message Board ·
16

VBA Code Stopped Working

Hello, I ised the following code a few years back but now its no showing any results. Could have been created in Excell 32 bit but not sure. I am looking through 3000 spreadsheets and copying the data in 5 cells from…

Q&A Formulas & Functions · MrExcel Message Board ·
19

How do I format and align buttons in Excel 2007 VBA?

In Excel 2007 I have 14 vertically oriented buttons in column P of my worksheet. I need some VBA code to format, position and align these buttons, namely: position, alignment (vertical, horizontal), width, height…

Q&A · Stack Overflow — [vba] ·

Related topics