Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is:
Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box
The sheet name...
The image shows an ActiveX Combo Box
On clickin the drop down the button does not present the linked list, instead it presents another drop down button inside the list area which when clicked presents the list required.
Not all persons in my team have the issue.
Changeing the combo box...
I am pretty new to VBA and I could really do with some help with a spread sheet.
I need to copy data from multiple rows (I only need up to offset 0,10 from these rows) when a cell in the range A1:A30000 in the sheet entitled DATA equals the value of TextBox7, to another sheet...
I have a macro I want to iron out... I need to copy/paste specific columns from one work sheet to another. I believe I have it to where when I run the macro, it will successfully copy/paste the columns.
My problem is the way I wrote the macro, it only knows to do it between two certain...
First off, I'm open to a variety of solutions for this situation. I'm currently working on using excel to make a searchable database of documents. I'm hyperlinking the articles, and have some advanced filter settings right now. I'm making a column that contains keywords that relate to the...
I've got problem. I receive phone number hashed by MD5 (00037b319ddf1495b2e7ae64e29a8ef5). I need to get this number from our mysql database.
So mysql query is: SELECT MD5(c.mob) phone, c.mob phone1 FROM db_hu.hu_cust c WHERE MD5(c.mob) IN ('00f9758dd73300b4025ea916c8a3e024');
I'm a beginner in terms of VBA and so I need help in finding duplicate data in columns then automatically deletes or selects them for deletion.
Here's a macro VBA code I found on the internet but it only displays the word "duplicate" in another column.
My problem here is there is already a VBA code for finding duplicates but the problem here is that.
It still takes too much time to click all the duplicates 1 by 1 just to delete them, for example:
Imagine a column filled with 5000 data and the duplicates found are around 1500, I can't possibly...
I want to rearrange some data in an excel table.
I have a variable ID_Nr defined as double and it is a number between 2 and 100. I want the macro to look for that number in column A and if found select the whole row and delete it.
That way I am trying to eliminate all rows with...
Hello everyone!! Hopefully somebody can help me!
I am using VBA to create an email from Excel that includes in the body of the message a table that I am selecting as an specific range.
The problem that I have is:
I have not been able to select just the dynamic range that contains values.
Hello I hope somebody can shed some light for me.
I have a macro button on my s/sheet that runs pretty well to highlight todays date within a row. However it also red borders the left and right side of the column below and im not sure why? It is quite useful and I would like to have the same...
I created a combo box in the form to select the record and export to excel (I created a button). Please advise how to make the combo box with one blank at the top of the list so that I select the blank, then all record can be exported to excel.
i want to select a value from dropdown list and have tried below code, but can't work.
please take a look:
<select name="fldcusval" nchange="fnSetBankName();fnSetCurrencyList()fnGetCustomer();;displayDetails (this);">..</selec>
I've received and modified a simple VBA from another excel and i was wondering if anyone could help me modify even more. The thing i need is that the range of this code would be across all documents worksheets.
I1,I2,I3 stays in the first sheet. Date and Name in any other if I2 or I3...
I have a code that will activate in a set range where the words "complete" are changed. I would like the active cell to select that row, however only from columns B:AB. All i have found is how to select the entire row.
Private Sub Worksheet_Change(ByVal Target As Range)If...
Hello Guys. Please help me with my little Project.
I have this project where i needed to link a database(Process2.excel) to another database(Process1.excel) so that it can automatically compute the offset adjustment(CNC Machinining) based from the Part ID's data from the previous process. The...
I would like macro to select the filter in A2 (Financial Year") on sheet summary if Cell c10 on sheet "Data" is zero, otherwise select highest year from Filter
Your assistance is most appreciated
<b></b><table cellpadding="2.5px" rules="all" style=";background-color...
I have a userform which has Comboboxes for which i select an item from the drop down list.
Once all the boxes are complete i then click my transfer button to entere it on my worksheet.
This is the code on my transfer button.
Private Sub CommandButton1_Click()
Dim i As Integer
I have a pivot Table on sheet "summary"
Where the value in C10 in sheet "Data" is zero, the year to be selected on Pivot filter in B2 must be blank , otherwise select highest year
It would be appreciated if some could provide me with code to do this
I have created a userform
Which have a combobox and a text box, save button.
Now when i select a value say"ABCD" in combo box, i will mention say number as "5".
Now when i click on save button, then 5 rows of value "ABCD" should be created in excel cells in the column i specify. And next time i...