activex

I have `ThisWorkbook.Sheets("MAIN")` and ActiveX `ComboBox11` on it. I also have table: A B 1 John 1 10000 2 John 2 20000 3 John 3 20000 4 John 4 10000 5 John...

Hello I am looking for a code that when the command button is clicked it will change "B1" Private Sub CommandButton2_Click() If "B1" = 1 then "B1" = 2 else If "B1" = 2 then "B1" = 1 I realize this is not a code it's just and example of what I'm looking for. Thank you

I know how to add a picture to the button (manually). Is it possible to create a code that when the button is clicked it changes to a different picture then when clicked again it changes back?

Hello guys, I want to write an excel macro that opens up sheets of word in directories per request and prints them out I already have a full path created for each file, so all i really need to do is: 1) Open the word document with specific name 2) Print out only page 2, this i can achieve...

I have a ActiveX ComboBox and the box is showing one of the items the list of items. When i try select from the box it flash another box and does nothing. In design mode i can see and select items in the ComboBox object which then changes the ComboBox. Why can't I just select from the...

Hey, I am a novice when it comes to using ActiveX Control and VBA to build macros but I am having incredible difficulty getting something simple to work. I want to build a macro which hides and unhides 3 columns in my excel sheet however when I run the macro it unhides unwanted columns and...

Hello everyone, I made a ComBobox (ActiveX control) with 6 items "FR5CP" "CR5CP "NR5CP" "CR5TP" "FR5CU" "CR5CB" I want a solution for this: when I write F it will filter the other ones and stay only FR5CP and FR5CU.I mean to look for the item while writing. nother Thing:when...

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

I have an ActiveX listbox on my sheet. I have a number of sub routines that run once the user clicks an item in the list. My issue is that once a user clicks an item in the list, the listbox appears empty briefly while the code is running, and the items show back up when the code is done. This...

The formatting for my original post messed up. I have corrected it below. I have a userform that adds, edits, and delete deletes entries from a sheet named ‘Data’ (Sheet 2). The first row of this dataset feeds into the 2 ActiveX textboxes that I have on Sheet(1). Upon adding an entry, I would...

Hi All, I'm trying to replace some ugly grey buttons in a document with ActiveX buttons. If I add a button, put some code behind it, exit Design mode and click on the button, rather than executing code a smaller copy of the button appears above and to the left of the button. If I then save the...

Hello guys, hope somebody can help me :-) I am working now with ActiveX controls and stucked little bit.. on sheet1 I have ActiveX Frame, inside this Frame I have another two frames and inside those frames, I will have textboxes...Do you pls know, how can I identify those textboxes and extract...

Hello! How are you all? Well, I have a problem, so let me first try to explain myself. I have a Table with a long list of items in Column A and I am trying set two Checkboxes in Column B and C. I found there is two ways to do this: with Form Controls and ActiveX. But they both have differents...

Is it possible to create a hyperlink to an activex combobox's listindex? So that the hyperlink would change the combobox selected item to combobox.listindex = 1 or listindex = 10?

Hi all. I'm trying to fill the list box (ActiveX) with names that have an active flag and skip names who don't have an active flag. <tbody> Tom Active Kenny Active Carrie Not Active Jane Active Ed Not Active </tbody> I created an named range that refers to both columns and entered it...

Thank you in advance for any help. I have been trying to create a play sheet for a game using active X controls. I'm stuck at the moment with my timer. I have 3 command buttons and a text box. The text box displays the timer, the buttons are as follows Start Game, Pause Game & Reset Timer. My...

Hello everyone, I am having an issue with ActiveX Checkboxes but I don't know what the problem is or how to fix it. So I have a sheet like this: [/URL][/IMG] And I have a code running to make everyone in column B have their own sheet. However, I only want that to happen if the checkbox in...

I have an ActiveX text box that displays text from external text files. This works correctly, but the font size of the text changes depending on whether I am selecting inside the text box (including the vertical scroll bar) or not. When the text box/scroll bar is not selected, the text is...

I have an ActiveX ComboBox and it uses a list to fill the drop down. When the user selects a company from the list, they click on the icon next to the ActiveX field to initiate the search macro. I would like to include code on the ActiveX ComboX so that when it loads, or is displayed, the...

I have two activex comboboxes, combobox1 and combobox2, that I want to increment with VBA from firstvalue to lastvalue. How can I change the value of the combobox so that I can see when it changes value from firstvalue to secondvalue to thirdvalue etc.. ?? So far I have found that they are...