controls

Hello, Why won't "control()" work inside a moduel which is called uppon from a click action of a button?? Basically this code works fine: (inside a module and the userform button calls this macro) Sub test1() If UserForm1.CommandButton1.Caption = "Unlock" Then...

Hi Guys, I was wondering if there's a such widget (in excel 2010) as a double-sided scrollbar control (activeX probably). Basically, I have a range, and I want to control the lower and upper limits of the range by dragging the 2 ends of a single scrollbar widget that has 2 sliders, one for the...

I have a series of checkboxes on my form, chb1, chb2 ..... chb10. I use some vba code, "for each ctl in controls" that goes through each checkbox. Ideally, I want to traverse each control in the same order (chb1...chb10). For some reason, it loops from chb1, chb2, chb3, chb4, chb6...

Hi, I have several Macros on this theme I would like to create all with the aim of copying a column and pasting values elsewhere in the worksheet according to what the current month is. Say I have a cell B2 with a dropdown of Months (Aug-Jul). I have a range "Spend_In_Scope_Forecast" which is...

Guten Tag As a work around to the loss of the Calendar-Control in 2010, I've sourced (googled) a class 'Calendar' with a nifty wee Userform (anyone who can help with this will be aware of such things) So I have several non-modal userforms in my App, some of them have date-fields that require...

I have a userform that asks the following- Equipment Type: [ComboBox] Qty: [TextBox] I have the code that opens the form and all of the initial controls - it is rather long but this is basically what it looks like: Private Sub UserForm_Initialize() With ComboBox_BoilerType...

Hi all, I have encountered the following weird situation. The following codes run well in the IDE (when we click the Green Play button). But the codes won't execute when actually using the excel file - after open the file, click the the "START" button, then a userform will be shown. There...

I am trying to use the following code but I am getting 'Run-time error '5': Invalid procedure call or argument' at the line of code which should disable the 'insert' Could anyone give me any advice. When trying to find help for this issue I have found the line of code numerous times and people...

Hi guys, I wrote some code using Controls Collection, let's say: UserForm1.Controls("cbBeg" & sTag & c).Value = wsTasks.Cells(iWiersz, b).TextThis code works in Excel 2007 I've tested it also in 2002 and 2003. But when I sent my application to another Excel 2003 user he's got Runtine Error at...

Hi, I cut and pasted an online survey from my website into an excel spreasheet. The page has a number of checkbox options which when one is selected, the others in the group are deselected, as expected. I can 'see' the checkboxes as "Control 1" to "Control 19" using the code below. What I...

Hi guys, Does somebody knows if you can search for controls in a userform collection, like in: / Dim ctl as Control / For Each ctl In UserForm1.Controls /"do action" but can exclude one specific subset of the collection of the action ? Like the subset: /...

Hello, I have a Excel App that developed in VBA and the controls on one particular worksheet automatically resize when I click them. I have changed the lock property to true and autosize false is set to false. But still the text in the button gets smaller and smaller everytime it is clicked...

I'm trying to get around VB library/reference issues by using late binding of controls/activex objects on a userform (instead of a worksheet) I cant get my button Click methods to work at all. I've even added a msgbox in its code to see if it gets called & it doesnt. Any ideas please? I...

Ok, so I have the following code that checks the textboxes within a Userform and if there is a blank text box, a message box pops up prompting the user to fill them out. The problem is, this code only seems to work in the userform from a top-down approach. In other words, if you don't fill...

Dear All, In an Excel 2003 workbook, I have several sheets. On one sheet I have Option Buttons. I am trying to change the value (true or false) of the buttons with code in a VBA module. I had code in Module1 to set the value of an Option Button: OptButInternational.Value = False I get a...

First of all many thanks to many of you for providing me with amazing solutions to my large and small Excel problems. So far I never had to post and so I never had an opportunity to thank you before this. What I want to do disable certain ActiveX toggles depending on the value of a specific...

Hi Everybody. I am trying to set all checkboxes and radio buttons on a spreadsheet to False every time a drop down list value changes and I am using the following code: Dim ole As OLEObject For Each ole In ActiveSheet.OLEObjects If ole.progID = "Forms.CheckBox.1" Or ole.progID =...

In Excel 2007, I am trying to add the Timer Control which I have available to me in VB 8. When I choose the option to add Additional Controls, a long list of Controls pops up which I can add, none of which I need. How can I make a control available to add as an additional control to add to my...

Greetings, Suppose I have a userform named myUserForm and a checkbox on it named myCheckBox. How on earth do I remove myCheckBox from myUserForm at run time? I've tried every which way I can think and I always get "error 444". Some things I've tried are: myUserForm.Controls.Remove...

Im creating a reasonably sized user form with a number of frame controls with inset option buttons. However in edit mode it is easy to either a) lose an option button control within the frame, or b) manage to drag the frame and lose it as it seems to 'bump' into another frame. Edit 'undo' will...