I am having trouble with my textbox 'correction' macro. What I want it to do is have the user select a line in a form control textbox. Then it should select the whole line and strike through it.
The code I use to add lines to the textbox is as followed...
Firstly, this forum is really great. I generally do my utmost not to post a new thread and read through other materials and try to work it out when I can. Here are some pre-existing materials on this topic that I already read through...
I Have a Table with a RANKING of employees like this:
I need help in writing a vba code which would connect to SQL and run a SQL statement to generate a report based on company name. The code should then save the output to the defined location in the excel data table
The data table in excel has company names from b2:b50. Column C is a user...
I need a vba code which could compare 2 worksheets which has data in different sort order
The data tables have no primary key and I need help in identifying how this can be compared to identify differences by reducing manual effort
Once the data is compared between 2 worksheets, the code...
I am trying to create a userform in a MASTER workbook where I want help in listing all Open workbooks including CSV files listed in a Userform combo box.
This combobox should include all open workbooks including the ones which are not saved in the local drive.
The master WB should be...
I found this great article (http://www.xl-central.com/list-the-files-in-a-folder-and-subfolders.html) and it is exactly what I needed.
I’ve tweaked it to reflect my circumstances, my issue is, I’m trying to pull certain cell Information rather than all the information about the file itself...
I'm in a worksheet and trying to extract the words after the 3rd and 4th hyphens when they're available in column A (see table below for representation).
Digital - workbook - sheet
Digital - workbook - app
Digital - workbook - test
Digital - workbook - sheet - max - version1...
Hello, I have the below code that works perfectly if you enter/copy data one cell at a time.
But I copy/paste multiple cells all the time, at which point the code below gives me an error.
Is there a way to adapt the below code to work with multiple cells changing at the same time?
I have seen multiple posts about removing old connections using VBA but they remove all connections. I have a sheet with 62000+ connections that have built up over time and would like to remove them and retain the 100 usable connections. Is there a way i can filter against the "Last...
I was wanting to see if there was away to add some code to my personal workbook so when I open and or save a workbook where the file path is more than 218 characters I will get a prompt telling me Ive exceeded the recommended character limit.
I have a workbook that pulls data from another workbook.
At present both workbooks have to be open for the data to pull through.
What I am wanting is a way to pull the data from 'workbook1' to 'workbook 2' without 'workbook 2' being open.
I cannot use vba as I also have another workbook...
I've been stuck with declaring a variable to a cell value and need some help.
Situation: I have a code that filters a table and transfers the filtered data to another sheet. The filter could be the date value but I can't set it properly. The result is always Error 1004.
Hello everyone I would like to thank you all in advance for your kind help, I have a good working knowledge of excel, BUT I am rather new to VBA and I could really use some of your help.
So I was able to create a simple formula that looked at cells Sheet2 A8 and B8 to create a hyperlink in C8...
Trying to extract 2 or 3 keywords from cell content through excel vba.
Sheet1 ColumnA has rows with content sample file attached.
I need vba to search for keywords from sheet2 ColumnA in Sheet1 and extract 2 or 3 or 4 keywords from each row content into sheet3.(Popup box would be...
I am getting a run time error 13 in my code between the **. Can anyone out there see why? For some reason the code will run and do what I want, but then spit out the error. Any help will be appreciated.
Dim i As Integer
I have the following code:
On Error Resume Next
Application.Calculation = xlCalculationManual
Application.EnableEvents = False
Application.ScreenUpdating = False
Dim wbCurrent As Workbook
Dim wsCHINO As Worksheet
Dim wsSTOCKTON As Worksheet
Dim wsFLM As Worksheet...
I have a program that generates between one to three reports for several different departments. It then is able to save the results as an excel workbook. I have written some VBA coding that I plan to use to formats these reports.
1) Is it possible for a script to “watch” a folder so that...
Hi, I would like to be able to determine the previous quarter from the current date and display as Q2 or Q3 or Q4 etc.<o:p></o:p>
I have the code to find and display the previous month (see below) but am unable to find a similar one for quarter. Thanks in advance.<o:p></o:p>...