vba & excel & forms

The code below here was written for me by @Fluff some time ago. It's a very wonderful code and I love it. I have added 2 more comboboxes to use as the criteria for doing my filtering but I am stacked with how to get it tweaked. The new comboboxes are: ComboBox3, which will check column Y and...

This workbook works fine for me but if somebody else uses the workbook it says "Can`t Find Project or Libary". When they press update on a user form? It`s on our server so should work for all of us? My Manager needs to see it today so somebody please help https://www.dropbox.com/t/QL0oGXslmXIJl3vd

In my workbook, I have several sheets which contain different forms and where the data is populated through vba program. I am able to print these forms only when the sheets are made visible, if very hidden the printing is not possible. I am adding thisworkbook.sheets("sheetname").activate...

Hello. I'm fairly new to VBA and not sure whether this could be done or not. I want to paste two rows data of data into an already opened workbook. I'll try to explain what i want in a bit more with an example. Consider a workbook "A" where data is entered manually by other people. Workbook...

I am new in excel VBA, I am looking for an Excel VBA code that will delete all the outlook email files (.msg) saved in local windows folder using 2 conditions and keep the last dated email file. The email files are from different suppliers that supply cement, steel and other construction...

Hi Team, I'm looking to run a VBA code from Sheet3 (Consolidated Report) that will check ID1 in sheet2 and when found it has to copy from Sheet2 ID2,Owner,Role,Role Status, and Role Title and insert copied cells (Cells shift down) respecting the cell in column A as the copied data starts from...

I am trying to submit one form in webpage using vba excel as inputs. I can see text appearing on each form fields but gets dissappear when I click on submit button. When I manually click on each field, the size of field gets extended and text won't dissappear. Can anyone please help why it is...

Hello everyone! I'm trying to import all folders subfolders from SharePoint to Excel. Can some one help me with this program error . Thank you in advance

I have a search bar/box which basically looks up Column A for the string that is searched, then if the string is there it is it filtered on that column and a 1 is added to Column J on that row. If the string is not in column A then Column B is searched and the same process as above happens...

Using VBA to find prices then fill prices to a different worksheet. I created a code below but it won't run it skips over the code and nothing happens. Sub UpDate_Stock_Prices() Dim JCMLastRow As Long, x As Long Dim DataRng As Range Dim PartsList As Worksheet...

I have a list box on my VBA form with a list of U.S. States. The person filling out the form will select states they wish to be licensed in for work. Following their selection and submitting the form I want the states they have selected to appear in 5 predetermined categories with a "," between...

Hi Everyone, This is my First Ever Post: I am creating a user form that will function similarly to a school management system. One of the elements that are part of it is a Pupil Profile, which shows all information relating to the specific child. Currently, each pupil has its own sheet. When...

Transformed(PRow * (c - 1) + 1, 39) = "=MAX(X" & Sum & ",Y" & Sum & ")-INDIRECT(ADDRESS(ROW(AC" & Sum + 3 & "), 28+X" & Sum + 1 & "))+ INDIRECT(ADDRESS(ROW(AF" & Sum & "), 28+(X" & Sum + 1 & "+1)))" Value 0 must be assigned to "Transformed(PRow * (c - 1) + 1, 39) " if the value is negative. So...

ok to start off with ,, thank for taking the time here to read this ive litterally been learning vla for 24-48 hours and im stuck with a few things i wondering if i could pick your brains to help soo.. ive attached a spreadsheet where im wanting to add a new line after pasting to my database...

so im ripping my. hair out here.. i have data which is in column format (data in cell, space, data in cell, space) and trying to copy that into another worksheet in row format using a macro to transfer the data across ive read and studied and searched all over and just cant get my code to...

Trying to use values from various Worksheet cells , Listbox and Toggle Switch Value for the dictionary See my attempt below. The code runs till it gets to this Line Set TPodWidth = UsForm.Toolpod_Width Then jumps over the rest of the code? Sub DrNoDict() Dim i As Long Dim ar...

Hello all, I am new to VBA and can read/modify some coding but am not fluent enough to write any from scratch. I have searched for many different pieces of code from others projects and tried to splice together but can't make it remotely do what I want. I have a master checklist based on a...

i have a program which has few sheets very hidden, my program is running very slow and hence i am using following code at the start of the Sub or Private Sub Application.Calculation = xlCalculationManual Application.ScreenUpdating = False Application.DisplayStatusBar = False...

In my user form I want to perform mathematical equation based on selection of one of option button (from 4 option buttons) and a check box. The purpose of selecting one of four option buttons is to perform mathematical calculation based one of four equations. The checkbox selection defines...

After I designed a userform with about 125 textboxes, 20 command buttons, 20 checkboxes, 20 comboboxes .. I am gettign a message that " Not enough system resources to display completely" This message did not pop up before this. Tried to change the default printer but no effect. But did not...