HI Excel Expert ,
Request your valuable help in solving the below error .
PS: Am new to Excel VBA coding .
I have got 3 Sheets in the attached workbook “Just combo V2”
Download link : Just combo V2.xlsm
Sheet 1
Sheet 2 =”School” in which Cell A1 : A14 Contains list of schools
Sheet 3...
Hi all,
I'm in need of a Check Box in Drop down list for multiple selection. The code which i had is given below. The disadvantages of the given code was duplication and unable to edit the selection.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim Oldvalue As String
Dim Newvalue As...
I've created the query on InvoiceID which is a large number. I have already created the search drop down box showing numbers in order. However when I select the number the Subform blanks out (there is data) rather than showing the results of the InvoiceId. I have used this code on other...
Good morning, I have a report with 500 separate account results - these are currently set up as a self serve via a dropdown. What I want to do is create 500 separate split worksheets based on the dropdown choice. However I want each worksheet to display all the results /charts etc which are set...
Hi,
I am recieving a #VALUE ! error when trying to copy the result of a data validation drop down in another sheet and dont know why.
e.g.
In sheet 1 I have a a drop down box in a cell (A1) that has recent dates in.
On sheet 2 I want the chosen date to show in a cell. I have put the formula...
Hello,
I'm currently working on trying to have a warning box that indicated when the drop downs have not been selected, but I'm coming back with too many formulas for this one box.
Currently I have:
=IF(AND(B4="Choose Current Grade", B6="Choose Proposed Grade", B8="Select Geographic...
Hello everyone,
I am almost done with a large dashboard for my company, and I feel a little lost on this final touch I want to add to it.
I do not know how to attach a pic, but i will try to explain in a way that makes sense.
In my Pivot table worksheet, i can get a slicer and be able to...
To Excel Giants Everywhere - Please help,
I am familiar with the general options for drop down lists... i.e. format the cell to reference a list and then check one.
Is there another solution where a user can check multiple options and then those options are stored in one cell?
If so, is...
Hi
I am looking to generate a list from a drop-down menu.
On sheet 1 there is a table which lists “keywords” in column A and “policies” in row 1. Within the table “x” is marked where a keyword is found in a policy.</SPAN>
On sheet 2 I have a drop down list with all the keywords and what I...
Hope someone can help...
I have a dropdown list of employee names to filter a matrix-style spreadsheet. On selection, all columns except the selected are hidden.
My problem is that every time I add a new employee, I have to modify the code to match the name to a specific column. I need code...
Hi All
I have a list of industries which I would like to have as a drop down box, to restrict only the industries included in the list.
I'm not sure how to do this. Any help please.
Many thanks
:confused:
Hey All,
Im trying to create a table based off values in another reference worksheet which will be generated from a value selected from a drop down box.
The values in this newly generated table is then to have a dropdown box next to them in which W or L can be selected.
the link below...
I have a dropdown box which I want to use to populate data into about 10 different cells on the top of a spreadsheet. There is a lot more data on the spreadsheet that I do not want to change with the dropdown box, this data will also feed into other sheets in the workbook.
Hi,
I am researching companies and tracking my research using an excel spreadsheet. I've created a rubric rating a company 1-5 with 5 being the highest rated/i.e. best potential sale. Each of the following items is rewarded with one point for each of the following.
1. High need of paper...
I am trying to use two seperate dropdown lists to select a specific value in a table of set values. The first drop down will select the row and the second will select one of two columns. I have the data validation lists ready to go but it looks like the main hangup I'm getting is having the...
Hello,
Is it possible that selecting an item from drop down should enter certain text in a cell ?
For example in cell "L7" there is a drop down with two items 1) pay due 2) Bill
Selecting (pay due) should enter following text
"Payments are due from the dealer, requires special attention."...
Hi
This is my first post. I'm wanting to know if there is a way to auto fill a drop down box.
For example I have a drop down box in Cell A1 which has an input range of $E$1:$E$4 and a cell link to Cell A1.
I now want to have another drop down box in Cell A2 with the same input range and but...
Good morning Mr Excel,
I am trying to create a formula that allows me to have different options populate a cell depending on the content of another cell.
I think i have done this before but cant remember the finer points,
=IF($C$7="Select Axle...
Hello,
I am attempting to use an ACTIVE X combo box. to deliver the desired function.
What i would like to do, is make a selection from the drop down combo box, and depending on what i select, have it populate other fields. PLEASE HELP!!!
Hello,
I have this code:
Code:
Sub comments1() With ActiveSheet With .Rows("180:186") .Hidden = Not .Hidden End With With .DropDowns("Tag1_1") .Visible = Not .Visible End With With .DropDowns("Tag2_1") .Visible = Not .Visible End With End WithEnd...