ctl

good morning all. if i am doing a "clear all" such as the code below, is there a way to do that and exclude a textbox from that? Dim ctl For Each ctl In Me.Controls If TypeOf ctl Is msforms.TextBox Then ctl.Text = "" End If Next ctl

How can I add to this formula to find the closest result in my temp. column? If I enter an exact temperature it will return the correct result. Ex: -17.56 = 1.11759 My formula is: =INDEX(C2:C8, MATCH(G2&G3, A2:A8&B2:B8, 0)) Any help would be appreciated...

Hi, I have a userform that I want to work in a way that focused control have a different back colour, making it obvious to the user which field they are in. I know I can apply this on a control-by-control basis, but I hate that manual stuff. It's inelegant. I've come up with a loop structure...

Hello everyone I have a userform with several commdandbuttons and I use the code below to close all, when I give instrution for that. But I need just one that must be open and not closed How can i do for that exception. Thank you Sub resertFormClose() Dim ctl For Each ctl In...

List box with Multiselect set to Extended. Does anyone have any code that deals with a list box using either the SHIFT or CTRL keys.

List box with Multiselect set to Extended. I have the following code on the click event of a list box. Dim ctl As Control Dim x As Variant Set ctl = Me!lstLandParcelReminders For Each x In ctl.ItemsSelected If ctl.Selected(x) = -1 Then ctl.Selected(x)...

Hy, (It will be long... :) ) I have a sheet with some data in columns like this example, but the actual worksheet has 30 rows and 40 cols: <tbody> A B C D E F 15 4 14 18 85 27 2 47 57 30 67 29 </tbody> (yes, i wanted to populate the numbers from every second column) The...

Hello everyone I have a macro below to open and close toggleButton (Tog1; Tog2; Tog3), only one at a time, in userform1. "MODULE" Sub TogClick (tog as ToggleButton) Col collection static like Dim ctl as control Dim vCtl as variant If col is nothing then Set col = New Collection For each ctl...

Hello, I am trying a different approach to handle required fields. I'm testing another code and where it highlights required fields works great. However, I need it to un-highlight after the required field has been filled. Below is the code that handles the required fields. Any suggestions...

Hi there, I have a few dozen textboxes on a userform, might add a few, might take a few away. Looking to change the backcolor of them all. My first question is: are textboxes counted as controls? So I'm trying to write using the following code - any ideas? Dim ctl As MSForms.Control For...

I have a worksheet with a userform with 24 checkboxes that I am attempting to use to open a workbook with 24 different worksheets. I want to use the checkboxes to select which sheets to print. The checkbox.captions correspond to the worksheet names and the checkbox.names correspond to the...