form controls

  1. tlc53

    Form Controls - Out of Control

    Hi, I have a spreadsheet which visually isn't large. One particular sheet for example ranges from A1:U159 and plenty of those cells are blank/unused. There are 4 sheets in total, 2 sheets have a bit going on and the other 2 basically just have a bit of text. However, this spreadsheet takes...
  2. A

    Code to Create an Active and Adapting List

    Hello, I have written a code in vba that asks for an input between -9 and 9. When a user inputs a number and pushes a macro enabled button, data that is greater than or equal to the inputted number is displayed. My problem is the output is taking up too much of my worksheet and I would like to...
  3. F

    Copy or Delete Range using VBA

    I have a range in cells A3:O19 named 'Report'. I am hoping to add two form control buttons, one to add a blank copy of that range starting in the first cell below the range above it, and one button to delete the last range on the page. Below is an image of roughly what I am looking for. If I...
  4. C

    Use a variable to identify to control on a user form in VBA

    I have a user form,SortForm that has 30 radio Buttons on it. The purpose of the form is to allow the user to pick one of the buttons to use as a key to sort the spreadsheet. It is sorting on courses and these change for each registration period. What I am attempting to do is change the...
  5. K

    Form control drop down box & protection

    We are currently using Excel 2007, The spreadsheet has a lot of different calculators involved and would like to protect the sheet and have only certain cells accessible. I created a form control drop down box that lists about 30 different vendors, the users would click on the drop down to...
  6. C

    Form not displaying controls

    I have a front-end application that contains various different objects (forms, queries, tables, etc) opened via a switchboard. After users log in, all can view most objects w/out issue indicating there are no problems w/ permissions or linkages to the back-end file. However, some users are...
  7. J

    Formatting of ActiveX Combo Box

    Is it possible to "conditionally format" an ActiveX combo box like you can a cell? What I am wanting to do is require a selection to be made from the combo box. I would like for the box to be red until a selection is made. Also, which is better to use? ActiveX or Form controls? I am very green...
  8. S

    cycling through listboxes

    `enter code here`Ok, so basically what this code is supposed to do is; -start a loop** -look up values and store them as variables -put all variables into the 1st listbox -loop back and -get new variables and... -...put in the 2nd listbox -loop 4...
  9. L

    Checking a box(?) to update formula range.

    I'm interested in modifying the below equation: =VLOOKUP($A$1,'High Level Costs, Capital'!$A$21:$I$35,MATCH($D3,'High Level Costs, Capital'!$A$21:$I$21,0),FALSE)*F3 I would like to have a check box or some variation (I'm open to recommendations). Example below: <tbody> Source 1 X Source 2...
  10. M

    Sorting form controls

    TLDR: Button objects, despite having the "move and size with cells" option selected, won't sort with cells in Excel 2010. Details: I made an awesome personnel tracker, complete with little "remove" buttons next to each employee that will archive the employee's data when clicked. After removal...
  11. A

    Form Control is Not updating range

    I have a user form that accepts user input and is supposed to put it on a worksheet. The form control has 2 textboxes, and IngredientName and Percentage. The user enters info into these boxes and clicks "Add Ingredient". This is supposed to place IngredientName in Cell G10, and Percentage in...
  12. M

    Problem disabling Form Control Button during macro

    Hi, I'm trying to disable a Form Control button if a certain Form Control Option Button is checked. The only problem is that the button won't disable, hence, allowing me to continue running the macro. My code is as follows: Dim optBtn66 As Excel.OptionButton Set optBtn66 =...
  13. S

    Worksheet Form Controls Stop Working After VBA Export to PDF

    As the title states, I have some VBA code setup to export sheets to a PDF report. There are check boxes on the worksheet to show and hide certain columns. After I run the code and successfully export to PDF, the form controls no longer work - I clicked them an nothing happens. Even if I save and...
  14. A

    Form catalog X activex catalog

    Hi all I have been using activex catalog buttons in one of my excel tools, but suddenly it stop working for several users (including me) - weird is that it is still working for others. I have compared versions of Activex, Excel etc... but everything seems to be ok. Because of that we decided...
  15. V

    Can you assign multiple click events to a button?

    Hello Excel Community, I have a control sheet that runs a variety of macros in my workbook, but I'd like to reduce some of the formatting control buttons if possible. Basically, I have some procedures that only hide or un-hide rows/columns for presentation purposes, but I'd like my users to be...
  16. D

    Combo Box and automatic treatment

    Hi, I would like to create a VBA script that allows me to organize and compute (and plot graph) different things depending on the sheet I select. To be more precise: I got (a lot of) different excel files (different months) with different sheets (different weeks in the months) with the same...
  17. S

    Radio Buttons linking to different cells

    Hi all Hoping someone out there can help with something that is probably very simple... but is driving me insane! I've created a survey with 5 "multiple choice" options for each question. I want to use a radio button to selcet one answer for each question. I have linked the five buttons to a...
  18. P

    Excel Form Controls

    When I put form controls onto a spread sheet is there anywhere I can easily see and access its properties? Format Control is lacking many values and I do not see them in the vba project toolbar. I am trying to get checkbox locations and checkbox numbers if possible. If there isn't an easy place...
  19. D

    How to select or open file folder and then choose a file using forms.

    So lets say i want to have a spin button that scrolls through each month of the year(or drop down button). And each month is the name of each folder.. how do I do that.. How do i select at folder level not at the file level in the folder ..Because after they select folder then i want a form to...
  20. D

    How to open file folders

    Basically i want to be able to use a spinbox in my form to select the month the user wants to open.. so there are 12 folders 1 for each month of the year. In each folder their are five files. All five files are named the same in each folder. I would like for the user to select month. Upon...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top