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...
I've used the following code in another workbook to open a calander pop up when I choose a particular cell and then once i've selected the date I want to select another cell.
I'm trying to use the same code on another workbook however the cell I want to use to start the pop up is merged...
I have a search option on my Userform enabling the user to search via Client or Opportunity name, and use the below code to find the result and populate various text/comboboxes on the search form. This enables the user to check it is the correct record before selecting it...
Hi, I have multiple sheets that are protected for using the standard Protect Sheet (select locked cells and select unlocked cells both ticked) but when the workbook is opened it prompts the user to provide the password to unprotect for as many instances that there are locked sheets in the...
Hi I have this table Query1 below. I want to return the distinct count of companies where the company is in the list of companies where the filter context of campaign = a and the date is greater than the minimum date of the filter context, which in this case would be 4/1/2019 because the...
I have taken this code from another worksheet & made the edits for it to work on my new sheet.
I type in the search box say AB & all the results with AB are shown in the listbox.
I select the item i require.
My problem is that the item i selected isnt selected on my worksheet in...
This is driving me nuts got my whole workbook figured out and I m stuck on this 1 thing. Its simple and I am just not seeing it any help please?
Dear Excel Experts,
In first row from Cell C1 to M1 there are name of persons and below 4 rows have specific numbers. I have set in column A all first row name by using data validation list criteria. I want a formula in column B. if a particular name select in cell A2 then at cell B2 shows all 4...
Hi - i'm using the code below to show open workbooks which the user can then select one. How do I update the code to allow the user to select multiple workbooks and how do I name them?
Code in a Module
Dim WB As Workbook
For Each WB In Workbooks
Hello, This is the 1st time I am working with OLAP Cube Pivots. Need help please.
I have a OLAP Cube pivot that has years from 1900 to current year. However it is missing few years in between. I need to be able to select all the years except for the last 15 years (2004 to 2019 needs to be...
I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this?
I tried the following macro but it doesn't work:
For Each cnct In ThisWorkbook.Connections
Hope you're having a good day.
I want to create a popup for a user to choose between three options
Select a file, Select a folder, Cancel
I made a userform to handle this.
If they choose to select the first option, I want to use Application.FileDialog(msoFileDialogFilePicker)