controls

Hi Does anyone have any experience in using the UXTheme.dll visual styles to create 'modern' looking controls in the VBA Userform? I've been experimenting with it, and I've hit a wall of sorts - especially when it comes to the Textbox. I would be grateful for any guidance or recommended...

Hi all. I have the following code to get the selected controls on a userform's designer module. The problem is that some controls are within a frame, in which case the frame itself is added to the collection instead of the selected controls inside it. I expect a similar problem to occur when...

Hi Folks, Excel Max has helped me understand a useful way to link option button choices in a userform to a Case SELECT inside my vba code. This code takes the choice of option box and returns it when the ActiveOption function is called from the userform code. Function ActiveOption() vA =...

Dear Guys, I have an older macro which ran well in earlier versions: when I right clicked on a cell and selected "Insert Comment": a macro ran automatically: of course I added following code to the appropriate sheet Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As...

Hey, guys. I put some CheckBoxes in my Form and make all of them invisible. Then I want to make only a few of them visible according to the number of Itens that the 'User' insert on a ListBox from the past Form. I also want to change the captions of these CheckBox to the same name of the itens...

Hi, I have done some sniffing around to see if I can find solution to my problem. I came close but needed a hand to finish it up for me. Dim allEmpty As Boolean allEmpty =True For Each crtl In Me.Controls If crtl.Name Like "txtM*" Then If Trim(crtl.Value) <> "" Then...

Hello, I have a userform with many Textboxes, Labels, CommandButtons.... I need to lock all the controls when the userform Initializes Instead of locking each control separate, I found this code on google that works well if the userform doesn't contain any label, else if there is any label...

Hello all, Now they want to add information to a form from the Excel workbook NoSparks helped me code. The code is in Excel and is below. I have it calling to where I have the Word template fine. It goes to a word document with more content controls then what I am requesting to be filled. So...

Some built-in controls (eg, idMso="FileSaveAs") allows customization of the screentip and supertip properties. Others, such as idMso="CellFillColorPicker" apparently do not. Is there a way to override these properties? TIA John

Hi everyone, I am facing an issue with Multipage. Controls are appearing merged/out of position when form is loaded When I click on another page and come back again to previous page it becomes normal Request to please suggest. viktiw

Hello, I am making a form and I want whenever a value of "yes'' is selected from dropdown list then certain rows along with controls appear (which have been already created). and whenever a value of "no'' is selected from dropdown list then those rows along with controls disappear. I tried...

I'm in the process of learning VBA and am working on a League Manager for my local billiard hall (The guy likes Excel). I have created a UserForm to enter scores and I'm looking for an easier way to code up my controls in it. I have a TextBox that needs to display the sum of values contained in...

Hello We have a very popular game we play at our workplace called bubble shooter. However after the company has updated to windows 10 and excel 365 the game no longer works. When I run the compatibility checker it says "Uninitiated activex controls can not be transferred to the selected file...

Hi I inserted UserForm and some other Form Controls such as textboxes/labels etc. I changed the name of each control for example TextBox1 to Mybox, Label1 to Mylabel etc. I also changed the name of the UserForm from UserForm1 to MyUserForm. Now, when I go to coding window, I see on the left...

hello all buddies, whats problem with my code below here, how come it returns column I-M with a wrong sequence? (column A-H is correct & prefect) <tbody> I J K L M N DATE CELL PHONE FAX REGION EMAIL expect 15-July-2005 1234 5678 NY abc@hotmail.com the outcome with below code NY...

Hi guys! I am having trouble figuring out how to do the following. Basically, I have a spreadsheet that I need to add controls to so the end user can re-sort the log based on how they want to see the data. Rows 1:6 are headers Print Range is A7:AG1525, but range will grow as new rows are...

Howdy gang Trying to do a shortcut - Userform is having dynamic number of items created at runtime for the user to interact with. I've done this successfully with Checkboxes, and that's all fine - but I was as I'm adding a lot of textboxes and comboboxes, and they all need an event fired on...

Column C has cells containing dozens to hundreds of control identifiers, with a comma delimiter. Each control has two letters, a hyphen, and numerical identifier. I have VBA script that alphabetizes the contents of each cell, but I need to parse out all the controls in each cell that don't...

Hi, I've some active X controls which have taken on odd behaviour. They are label and combo box controls. As I mouse over them the cursor becomes a 4 pointed thing whether I go to design mode, or not. There's no dropdown action. A right click shows a different menu to the expected one starting...

Hi, I have 5 or 6 sheets in a workbook, and each sheet have around 5 to 10 ActiveX controls, and in Workbook_Open event I am filling values in these ActiveX controls, but when the Workbook_Open event fires and go to the procedure where I am filling those ActiveX controls, there is an error...