form control

I have a worksheet with a named range that consists of 7 rows within 2 Columns. Ie. G:10-H:17 The user inputs data into 2 text boxes in a form, one called "material", and one called "price" the data inputed in "material" goes in to g:10 of the range and "price" in H:10. The user can then add...

Hi All, I have tried searching numerous forums to help, on what I am hoping is an easy solution! I am creating a dashboard and have a combo box driving cells in my dashboard. One of which is a cell which contains a summary of text. I have created a spin button which allows you to scroll...

I put a number of checkboxes in my Excel spreadsheet. I linked a couple of them, but now want to copy and paste those with the formatting over a larger area, but it isn't working. I am getting the formatting or linking not associating with the correct cell location. For instance, if the...

I can't for the life of me figure out how to group non-activeX option buttons. I want to be able to group all the buttons in the "for j to Opt_Btn_count" loop. Does anyone have any idea how to do this? Sub Add_XOptionBtns() Dim CLeft, CTop, CHeight, CWidth As Double Dim lotarget As...

Hi all, Thanks for reading. I have what I think is a very easy issue (annoyingly I cannot seem to solve it :(). I have some code that works and resets all my checkboxes in my worksheet, and now I've got another worksheet that I would like to split out resetting different columns. This way I...

Hi all, The spreadsheet has a combobox (Form Control / NOT ActiveX) named ddlCombo. It has the following values: Alice Bob Charlie What is the line of code to make the value "Bob" selected in the combobox via VBA. Thanks.

I've tried this every which way I can think of and I'm having no luck. I want to make the excel page as easy to use as possible on a touch screen surface. Ideally I could add a page up/page down button on the screen or enlarged scroll arrows. I tried adding a scroll bar form control but that...

Hello everyone, While I know how to use option buttons in the Developer tab under Form Controls, I am new to the ones in ActiveX. I believe I need to use the ActiveX ones, based on the following criteria, but correct me if I'm wrong: 1. I have 5 sections on the same "survey" form (one page) that...

I have some couple of functions/ macros on activex and form buttons. One function is to go to the last empty data on a column, and many others. I reformatted my PC, now the everything stops working. I understand that some files/softwares/updates were removed during reformatting I just cant tell...

Hello all! I have a question regarding Form Control Combo Box. I have developed a very simple Combo Box in Form Control where I have a list of 16 cities. When selecting a new city, I want a corresponding cell ($G$1) to update to the new cell I've selected. So, if I select Atlanta from my...

Hi, As a complete newbie I really seem to be struggling with this problem and am hoping that someone has a nice easy answer. I have a sheet which is essentially being used as a questionnaire. On the sheet are a number of group boxes which each contain up to a maximum of 8 option buttons (all...

Hello Mr.Excel, I wrote a hide rows VBA on Excel 2013 (see the code below), it is working fine. But when I opened in MAC Excel 2011 the button is not working (it become static buttons). I have the button as "form control" Private Sub OptionButton_NA_No_Click()...

Hello all. I am looking for a way to use a form control button to check a series of checkboxes in a worksheet. I'm new at creating macros and I am having trouble creating an If serious for Value that can convert the button macro to the selected range change. This is a call sheet I have been...

I'm creating a custom function to cut down on redundant code. However, in converting the code to a function so that it may be used in different instances, I'm getting an unexpected error when the code executes. The error is: Object doesn't support this property or method. Here is my...

Hello, I need some help with a form control (not active x) combo box. I want it to force the box to drop down when another button is clicked. The reason for this is that a user can't click on a dropdown arrow if they still have an active cursor in another cell, but they CAN click on a button...

Hi Guys, I have a button in Access Database, but i don`t have a functionality. I need whenever i press "Import Button" it will automatically open the filer and i will navigate to select multiple files of excel anywhere in my hard drive. when i import the data it will automatically import all...

I have the following: * a drop-down list (linked to cell M1) * an Image ActiveX Control container (generated with the Camera button, as i assume that will be the same) When I select alternatives in the drop-down list different images appear in the Image containter. I have stored the images in...

Hello everybody, this is the first time for me to post a question here and I hope that you can understand the problem that I'm currently facing :) Furthermore, I'm a total VBA noob (really, I just started a few days ago) and also don't have any programming experience at all. Ok, here I go...

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...

I'm playing a volleyball tournament recently and was thinking of setting up the lineup for our starters. Since there are rotations in volleyball games, I was wondering if there's an easier way to press a "toggle button" (except I have 6 different statuses instead of 2) and a clock-wise rotation...