Creating A List Of Buttons To Make Selection
Jun 3, 2008
I haven't used buttons much.
I would like to create a list of projects in column A.
Then the user would select one of the projects. This can be done by clicking on the corresponding cell in column B. So I would lkie to see buttons in column B for this. OR if someone can suggest another way, e.g. highlighting the project name in column A or putting an x in corresponding cell in column B.
I can make this last scenerio work, but I don't know how to assure that only one project can be selected at a time.
In other words if I have selected project in ROW 12 and then I want to see project in ROW 17, I should be able to select 17. And 12 should be deselected automatically.
View 10 Replies
ADVERTISEMENT
Jan 13, 2009
I am trying to create a fairly simple spreadsheet with about 8 columns and about 400 rows. One of the columns features a drop-down list with about 8 or 9 different options. Dependant on which option is selected, i would like the entire row to change colour with that option.
For example:
FAILED - whole row changes red
SUCCESSFUL - row has no fill
Tested - row changes to orange
etc.
Is this possible within Excel 2003?
View 9 Replies
View Related
Dec 6, 2012
There are multiple training sessions that will be rolling out in Q1 13 and my manager needs a way to track which empolyees have been to which training sessions. Easy enough. He wants something extremely clean looking, but obviously efficient. What he described to me (his vision) is to have the training sessions listed into columns with drop down under each that contain every employee's name. So when a training session is held, he can easily click the drop down beneath the session title and select multiple persons that were in attendance. Right now I just have all the employees listed in column A and all the training sessions listed across the top and anticipated just putting a "x" in the box for the session that each person attends. This will accomplish exactly what he's looking for, but if what he's describing is remotely possible I would like to do that.
View 2 Replies
View Related
Dec 16, 2008
I'm trying to make a macro that creates a button (to run another macro). I'm also trying to make sure this has a specific name, instead of just "Button#". The code I get from recording this is:
View 5 Replies
View Related
Sep 1, 2009
I want to have 2 groups of option buttons, and create them similar to the way I've created textboxes (as shown here):
With Sheets("sheet1").TextBoxes.Add(10, 5, 100, 100)
.Interior.ColorIndex = 4
.HorizontalAlignment = xlCenter
.VerticalAlignment = xlCenter
.Caption = "Check Selection"
.Border.Weight = xlThick
End With
When I try:
With Sheets("sheet1").OptionButton.Add(20 , 5, 100, 100)
I receive a runtime error 438
Also, how can I set up the grouping options, and have a default selection already picked?
View 9 Replies
View Related
Aug 17, 2006
Is it possible to create a number of command buttons, depending on the number of lines on a worksheet, and then have the code attached to the command buttons execute based on the position of the buttons on the sheet. For example, if I have a button positioned over, say A3, can the code execute based on the content of another cell in the same row. I imagine that the button would have to be linked to the cell, but I cannot see how that is achieved.
View 8 Replies
View Related
Sep 21, 2009
I have a spreadsheet that has
worksheet_calculate and also worksheet_changes, its a combination of the 2...
and it's purpose is to make a record of the number every time it changes by populating it into the next row, so I end up having a very long data list
and what happens is that my spreadsheet has real-time data coming into one cell which makes it constantly changing....
needless to say, when my spreadsheet is opened, it starts to do it immediately...and it wont stop as long as the number keeps on changing.
I would like to make 2 buttons - one says START, one says STOP
and when I click on START, then it will start making record of this number and when I click STOP, then it stops recording the changes of this number.
View 5 Replies
View Related
Nov 22, 2008
I have a group of 3 Option Buttons that are grouped by a Group Box. I added another Option Button and placed it in the third position, moving the button that was originally third to the bottom. When I select the fourth button (that was originally the third of three) it still returns a 3 in the linked cell, and when the new button (placed in the third position) is selected, the linked cell returns a 4. How do I change the order that the linked cell sees? In the attached spreadsheet, the Group Box in question is the Pricing Method on the Tow worksheet.
RateCalcApp.xlsm
View 3 Replies
View Related
Sep 30, 2009
I have a userform with a combobox for material description. When a user selects a value from this list I would like a popup box to appear that contains four buttons that correlate to material type. When a particular button is selected from this input box, that value is then appended (concatenated) to the original selection made from the combobox. I have set it up where the user can "enter" a choice but I would rather it be a "pick and click" entry.
Also, is there a way to rename the vbYesNO buttons in a message box?
View 9 Replies
View Related
Jun 17, 2014
by using radio buttons or checkbox, or anything similar. Based on the answer, I would like cells to appear below the question, for example in B3 another question would be "how many guests would you like to invite?" and B2 would be their answer but is preset to "0"
View 3 Replies
View Related
Oct 27, 2009
I have a form with at about 1200 checkboxes and I need to make them behave as radio buttons. What I mean is that just one box can be selected in a group of boxes.
Lets say i want to group all 1200 boxes in 400 groups, with 3 check boxes in every group. I want user to be able to select just one check box in every group.
View 12 Replies
View Related
Jan 21, 2009
Create a button for protecting the worksheet and a button for unprotecting the worksheet
View 13 Replies
View Related
May 29, 2007
I have a workbook that creates three temporary menu buttons when I open it. These work fine until I try and open more then 1 workbook at a time. This creates duplicate menu buttons (3 times the number of workbooks that I open).
I call up the procedure when each workbook is opened using this code in the "ThisWorkbook" code area: ....
View 9 Replies
View Related
Sep 4, 2008
Is it at all possible to create a User Form where the number of CheckBoxes will be linked to the number of entries in a cell range?
For example I have a 3 records in the range A:A called "Blue", "Green", "Yellow". I want to have a user form with 3 CheckBoxes with the same caption names.
View 9 Replies
View Related
Jun 30, 2009
Is there a way to light up a row when a cell in that row is selected?
I'm working within columns A through H.
View 5 Replies
View Related
Nov 14, 2008
I have a pricing model I'm working on where the request is to have all of the line/part items in the model, but only display a subset of those items based upon a sub-line chosen by the user by a drop box that includes all sub-lines.
Right now the list of parts is a table that I'm querying that also includes a simple '1' or '0' to indicate whether every part is an element of one or many sub-lines; eg (sorry, sure this won't format right):
Item SubA SubB SubC
210-1010 1 1 0
210-1011 1 0 1
So if choosing SubB in the drop box, I need the autofilter to show the first part, but not the second one. I think I have to do it this way (autofilter) because it will retain all of the parts whether the user is looking at them at this moment or not; they will use this tool to perhaps first price all SubB items, *then* go select SubC and price all of *those* items - and it needs to retain everything they've done, rather than a dynamic query that would lose prior changes and pull in a whole new set of data (if that makes sense).
So.... I need my autofilter to react not to specifically choosing data on the autofilter itself, but to a choice made in the drop box (probably a macro/VB attached to the box that reacts to the linked cell value that results from the choice, but I don't know how to tell it if the linked cell value is '5', go to column 7 (first two are part number and description) in the autofilter and filter on that column.
View 13 Replies
View Related
Dec 30, 2009
I designed my spreadsheet incorrect.
Everything works good. But when I selecting tables with listbox, I forgot to notice that there also comboboxes.
I mean, rwgrietveld, I use selecting table to hide 'em, but when I hide 'em comboxes should also disappear (become invisible).
is it possible at all to make invisible activex commandbutton in selection?
View 11 Replies
View Related
Apr 18, 2013
I have my dummy data, and I have (what I think) is how I want the data to be shown. My friend uses Google Sheets, but I prefer Excel. I am trying to convert the code because I am a stickler for excel. Typically I can convert codes some easily, but this is way beyond me.
For Column A: I want to create a list on sheet 'Setup!' based on ids!D2:D="yes". If that list has duplicate entries, I would like only the first entry to show up, but for the next entries I would like the cell to be blank. (this is important for the next step) For Column C: I want to have the corresponding dates go with the name entry. For Column D: I want to have the notes go with the corresponding date entry. (I believe I can manipulate Column C's code to do Column D myself).
I am also going to upload a data sheet, and an expected results sheet.
unique list.xlsx
View 1 Replies
View Related
May 17, 2013
i have many excel workbooks in a folder i want a macro that will get the names of all the files and make the file names so extracted as a hyperlink to open the files.
View 1 Replies
View Related
Jun 24, 2009
I am trying to create a drop down list that when selected will display data in the 10 rows below and 4 columns, so a total of 40 cells. I would like the data to be based on the selection in the drop down list.
The data looks like this,
RequirementsQtyResourcesQty
Level 1 Sentinel10Level 1 Sentinel105
Level 2 Sentinel10Level 2 Sentinel167
Level 3 Sentinel10Level 3 Sentinel156
Level 1 Banga20Level 1 Banga401
Level 2 Banga20Level 2 Banga307
Level 4 Banga20Level 4 Banga0
i have 27 different combinations of the above list with up to 10 different rows. I have a label for each one, but i cannot get the rows below my drop down list to display the proper values base don the selection in the drop down list.
View 8 Replies
View Related
Jun 11, 2013
I'm creating a spreadsheet to keep track of my costs of production in an online game. Within the game there are a range of spawned resources that appear for only a short time before being unobtainable these resources have specific types that is shared between multiple spawns of the resource but each resource spawn has a unique name.
My first worksheet lists all the resources and their various qualities and the later worksheets are meant to allow me to choose from a list resources matching the requirements of the item I'm looking to craft. The example i have shown in the second picture requires Tatooinian Fiberplast and Lokian Wild Wheat to craft so in the Chosen Resource column I would like to have a drop down list allowing me to select the named resource type i would like to use - for Tatooinian Fiberplast the only thing on the list should be Omnitwixi and for the Wild Wheat it should show Fizi and Krad
[URL]....
[URL]....
I am aware there are people with more pressing problems than computer games and as such
View 7 Replies
View Related
Jul 28, 2009
Basically I have a giant list (50,000+) of area codes (like 312, 216, 517, etc...) and I would like to make a new column right next to that, which takes those area codes and transcribes them into states so it would be (IL, OH, MI, etc...)
I have a table on the 2nd page of my excel workbook which has every single area code listed in column A, and in column B it has all the state symbols. I got it from here: .....
View 9 Replies
View Related
Mar 21, 2014
A
B
c
d
[Code]....
So the data I put in Is Cells A to D the reast are calculated for me. so for example E2 is looking down column D to see if the number matches the number in A2, If any of them do it will put the name in the corresponding cell in E2 (Or you ca use a different cell if you prefer) so in this case D3=A2 so B3 is the answer also in the cell next to it I need whatever number is the cell next to the answer so in this case C3
View 3 Replies
View Related
Jul 31, 2008
I have a list of 200,000 e-mail addresses in a excel document in column A. What i am trying todo is find all the duplicate e-mail addresses within the list that appears more than four times.
I have tried this forumla in colunm B so it lists how many times the record appears: =countif($A$2:$A$244270,A2) which works fine and then a number appears next to each record. Then i pressed the sort filter to arrange all the records in number order so all the 5's are at the top of the worksheet but that does'nt always list them in the correct number order.
Basically all i want todo is find all the records that appear in my list more than five times then make a list of just one of those 5 records so i can remove them from my e-mail system.
View 9 Replies
View Related
Jul 28, 2009
Basically I have a giant list (50,000+) of area codes (like 312, 216, 517, etc...) and I would like to make a new column right next to that, which takes those area codes and transcribes them into states so it would be (IL, OH, MI, etc...)
I have a table on the 2nd page of my excel workbook which has every single area code listed in column A, and in column B it has all the state symbols. I got it from here: [url]
How would I go about making this new column on page 1 of my workbook which takes all the area codes I have and makes a brand new list of the states by looking up the area code/state table I have on page 2 of the workbook?
View 9 Replies
View Related
May 8, 2014
I would like to be able to compare the "standards" in Column A with the Assessment status in Column B and the Assessment period in Column C in order to generate a compact list in another workbook (ideally) or tab (if not). A list might typically contain all the standards that have been M (mastered) during a given Assessment period. I realize that filters would achieve this to a large extent but I was hoping to automatically populate another worksheet or tab.
View 3 Replies
View Related
Jan 27, 2012
I am trying to make a spreadsheet for a customer and would like to include a feature where the list of parts can be expanded or compressed with buttons.
Each SO# has a set of PO#'s associated with it, and it would be nice if the viewer can choose to see the PO#'s or not see them at will (this will make a lot more sense if you see the spreadsheet example in my link.)
Ideally, there would be a button next to each "SO#" which would expand/compress accordingly. I don't want just a universal button that would expand/compress all of the SO# at once (although having this option on the side would be nice).
here's link to my spreadsheet: [URL]....
View 2 Replies
View Related
Mar 17, 2014
I am looking for a Macro that would randomly select 20 items from my inventory list for performing spot checks. Column F of Active Coil Log tab is where the data would need to pull from, however I would like all data in the row to go along with it. I've explored the RAND functions, but they don't seem to be the right fit .
View 2 Replies
View Related
Feb 20, 2013
Maybe this problem is not too much complicated for some of you experts. I have this:
I have in sheet "Products", in column A, a lists of Products from row 2 to N. (Product 1 , Product 2, Product 15, Product 37, etc).
How to generate in sheet "Menu" a matrix of buttons with the label of each button taken from the value of each cell in column A of sheet1.
I mean, the buttons would have the label Product 1 , Product 2, Product 15, Product 37, etc. Each button associated with macro "My_Macro".
I would like that the buttons be organize as simetrical as possible (regarding number of rows and columns)
* I'm attaching sample file with input in sheet "Products" and output desired for those few products. The real list could have 100 Products.
View 6 Replies
View Related
Mar 19, 2009
I have a list of names in column A, don't know how many different names but for sure some of them repeats in different cells of column A.
A1 = NAME_1
A2 = Alan
A3 = Ben
A4 = John
A5 = Alan
A6 = Kevin
A7 = Mark
A8 = Dominic
A9 = John
A10= Tom
A11=Alan
A12=Frank
How can I make aonther list in column B, which contains a list of name in column A without repeating. So that B1 = NAME_2, B2:B4 is exactly like A2:A4, then B5 = Kevin, B6 = Mark, B7 = Dominic, B8 = Tom, B9 = Frank.... and so on. Another question, which is very similar to the previous one. In the same column A, now I add an AutoFilter (Data > Filter > AutoFilter) in A1. A drop down arrow button will appear at the right side within A1. Click the down arrow and another box shows: Sort Ascending, Sort Descending, All, Top 10, Custom, Alan, Ben.... the rest of the data in Column A but each unique data will only shows once in that list. How can I copy the contents of that box?
View 5 Replies
View Related
