This code allows me to use the scroll wheel on my userforms.
I've been using this bit of code successfully but now i have a 64 bit system and its throwing up the following error:
The code in this project must be updated for use on 64-bit systems.
Please review and update...
I am using the attached code for converting numbers (currency) into text. The code was working fine but now gives a
"Compile error : Cant find project or library"
please help to find what has gone wrong now. the code stops at "ReDim Place(9) As String" line.
I am converting an existing MS Excel spreadsheet from Office XP to Office 2016. When running the VBA code I get an error.
Run-time error '445':
Object doesn't support this action
The debug windows highlights this part of the code: Set fs = Application.FileSearch
Hi, I am having trouble reffering to any workbook using workbooks statement. Every time I try using the workbooks statement I get compile error despite copying the code from tutorial. Example in the image. Any suggestions? Thanks
Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...
Hi, I have 2 scenarios where:
1. I have an integrated VBA form where values are input manually in a textbox and I get results outputted successfully.
I was able to find an i.e. =embed((m1r1) command in the textbox but can't seem to access it again.
The first sheet has code like this...
I need to disable AutoSave in a certain file when opening. The solution posted here works fine on my machine with Excel 365, however other people have encountered problems.
I have Office 365, but others have Office 2016 (both of which are considered Version 16 apparently, albeit...
I have a custom tab from UI Editor. I keep getting 'For without Next' error and it highlights the End Sub. Have no idea why. Please help!
Sub DC_Split(Optional ByVal Control As IRibbonControl)
Application.Calculation = xlCalculationManual
Application.EnableEvents = False...
I have a workbook with code referencing activex objects that isn't supposed to be ran on if the user is on Mac, however after the user gets out of the initial read only mode upon receiving the document, ActiveX objects are deleted. Trying to run certain macros will then result in compile errors...
Sorry if this is in the wrong location, this is the first time I am posting on this forum.
My issue is a regarding a "Compile Error: Method or data member not found" that happens when an excel file is opened by some users. These users have either excel 2013 or 2016 installed.
The compile error...
I am running a macro in excel and i am having trouble with this error popping up and highlighting the Year(DATE) formula in my vba. i have searched and searched and have found things on how to replace the referrences but i dont know what reference to use to solve this issue. my program runs...
I don't know why I keep getting this error. I've tried BeforeUpate,AfterUpdate, enter,exit....none of them work.
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
Dim Username As String
Username = TextBox2.Value
MsgBox "Hello, " + Username + "...
Before I go back to the drawing board, can anyone see whether they can get this VBA code to work?
Basically, I have two drop down lists. One is "No. of Investments" and the other is "No. of Partners". I would like certain rows to hide, depending on the result of both drop down lists...
I have created a Macro as follows to create a web query and loop through the alphabet to append the data of multiple queries into a worksheet. The macro is connected to a button on one of the worksheets in my Workbook.
Issue: I can run it on my computer (Trust Center settings set to Macros -...
Hoping you can help with an error i'm encountering when running a script to create a temporary copy of the workbook > attach it to email and send using outlook. I get an error on:
TempFilePath = Environ$("temp") & ""
The exact error message is: "Compile Error Can't Find project...
So the current error I get is an End With without With
I've tried to add something that has "with" and then I get the error "For without Next"
and if I add a Next, then I get the error "Next without For"
What the heck am I doing wrong?
I'm trying to do the following tasks:
1. Create a folder...
VBA Will Not allow me to enter this formula as shown below............
ActiveCell.FormulaR1C1 = "=(GETPIVOTDATA("Total",'TKOFF Summary'!$A$3,"LEVEL 3","D" & Select_Row,"Area",F7,"CSI MF CODE","H" & Select_Row,"ITEM DESCRIPTION","I" & Select_Row,"Unit","K" & Select_Row7"
I keep getting the...
I have some code that I have written. I had it working then made a small tweak to it. The code publishes a letter of customer specific data from a template held in the workbook. I have been tweaking with the original code to change formatting and the eliminate pre-existing SQL queries that are...