ws.cellsi

Hi all, I'm sure I'm missing something small, but does anyone know why I have to use "LastRow-2" in the code below to keep from ending up with 2 empty rows of data at the bottom of my ComboBox list? I guess I would get it if I had to use LastRow-1 since the array might be putting in an extra...

Could anybody help me a bit here please, I have some code which opens all the files in a directory & copies and pastes information onto a sheet. I need to modify it so it will open all files except one file named WIP. I did try modifying this line Do While myfile <> "", but it just gave me an...

Hello everybody, I have this piece of code that is adding drop downs to where is the end of the data. Now, from the first blank data, exactly where the end of data is, I need to continue adding 1000 more drop downs with different set of values. I have another set of codes below that adds only...

Hi !! I have this code I have been using which fills up a textbox dependent on a selection from a combobox. Currently I have been trying to modify it to be able to fill the textbox based on the selection from the combination of 2 or more comboboxes. For example, if I have: ComboBox1 = First...

I've never posted on here before so let me know if you need more information. I'm also not an expert in coding but have been doing basic coding for awhile. I created an inventory tracking sheet but some of the products were being entered more than once. I'm trying to create a find system that...

I'm new to vba and need help with a vba script. I have two command buttons that were created within a UserForm1. I've tried to run the second by using "Call", but it does not work. Is there a way to run button 1 first, then button 2 immediately after 1? Public Sub CommandButton1_Click()...

Hey guys! I am having an issue importing JSON into Excel. I am using the VBA-JASON converter from GitHub and I the parse command woks fine. However, I can't get the loop working... I get an error saying 'Object is required' for the loop command, but I can't figure it out.. Don't judge me too...

Context I can currently search for an ID and populate values in my userform. I can amend or change values and click an update button and it uploads the new data - code below: If (TBID1.Text) = ws.Cells(i, 1) Then ' loop to find relevant ID within the data ws.Cells(i, 1) = TBID1.Text...

Hi, I've a code to import a Json text to excel. There is a way to do a web request to login to the site (probably get cookies too) and parse directly the json url? Sub ConverterJsonEfatura() Dim jsonText As String Dim jsonObject As Object, item As Object Dim i As Long Dim ws As Worksheet Set...

Hi all I have a form with two combo boxes, both populate from the same column. I want to amend the second combo box list to exclude the value selected on the first combo box. the column is a list of locations, the form allows two locations to be selected <Code>Private Sub UserForm_Initialize()...

Can I place specific value into an array and then use the array with a loop to delete row if value in array is in cell. i.e. Place West, North, South in Array then use the following code. dim arr as Variant For i = lastRow To 2 Step -1 If Ws.Cells(i, "H").Value = arr Then Ws.Cells(i...

Hi All This code works fine - i think how can i amend this code to make it shorter/neater and speed it up All im doing with the code is seperating each line by a question (currently all questions are across) Hoping someone can help me Many thanks Sub transposeme() Dim RawDatash As...

Hi all, I haven't posted on the site for a long time so how everyone is well. I have a basic userform that uses a combobox to return and populate some text boxes. the combobox returns the name of a client as and when they have contacted me. the problem has accrued when adding multiple contacts...

Hello all, I had an issue trying to connect to my first API call from Excel and John_w really helped. Thank you John. I now have the need to connect to a free API travel website https://iatacodes.org/. I am getting an error in parsing the xml. All help is appreciated. Regards, Marc Sub...

Good Morning all.... Got an odd one in that what I have is working, just not well.... I have a sheet with two columns and 100k plus records Col A contains a text description that is fetched by a VBA Cut and Paste from another sheet. In ColB I have automated a COUNTIF to copy from Row2 down...