Can ActiveX Control Button Macro Be Placed In Regular Module

Feb 20, 2014

Can Active-X control button macro be placed in a regular module, or does it always have to reside in the sheet module?
Or is the only way to accomplish this is to have the macro in the regular module being called from the button macro in the sheet module?

I somehow seem to remember a way to move/assign an Active-X ControlButton macro to a regular module, but maybe I'm wrong?

View 1 Replies


ADVERTISEMENT

ActiveX Control Button Changes Size For No Reason

Feb 18, 2014

I have created several macros where i use an active-X control button. This button is pressed and the macro begins...........but every now and again this button changes size for no apparent reason.

I have read countless articles/posts about what "may" be causing the problem but i have never read anything which clearly identifies the soln to this problem and the problem has been out there for years. To make matters worse the problem can not be duplicated on any regular frequency that i am aware of............so its not like i can post a file that will show the problem.............

View 4 Replies View Related

ActiveX Control Button Not Copying And Pasting?

May 14, 2014

I am using the following code to copy a template to a new worksheet each month:

Code:
Sub CopyTemplateNewMonth()
Application.ScreenUpdating = False
Dim SourceRange As Range, DestRange As Range

[Code]....

Everything copies over except an Activex Control button. I also have form control buttons with macros assigned to them, and they copy & paste just fine. The code assigned to the ActiveX button also copy's & paste's just fine...but the button itself does not.

View 9 Replies View Related

How To Use ActiveX Control Checkbox

Jan 9, 2012

I am trying to create a workbook where the first worksheet has a list of Checkboxes and each checkbox 'unhides' or 'hides' subsequent worksheets within the workbook, depending on whether the box is checked. I can make the checkbox, I can record the macro.

Sub Test_checkbox()
' Test_checkbox Macro
Sheets("Dist").Visible = True
End Sub

How do I link them together? Ideally, I'd like to have my boss be able to 'play' with which sheets are visible (check, uncheck, check, uncheck, etc) .

View 4 Replies View Related

Max Length Of ActiveX Control Name

Mar 16, 2012

What the max length of an ActivX Control name would be. I mean the name that you would use in coding something, not the actual caption name of the button. IN this case I am using a radio button.

Based on that I would like to create random IDs to assign to the button. I know how to do this in the cell formula but not in code.

View 3 Replies View Related

ActiveX Control Can't Create Object

Jul 28, 2009

I copied a routine from this forum that would email a single sheet from a 10-sheet workbook to a recipient. This worked great for a long time, then all of a sudden I started getting the "ActiveX control can't create object" error. Here is my

View 14 Replies View Related

Transparent Background Of ActiveX Control

Jan 6, 2010

I have an ActiveX Label control with a transparent background. When I click on the label the background turns white and stays that way as long as the mouse is over the label, obscuring whatever's underneath. (It also very slightly alters the character spacing.) What object/property controls this? How do I adjust it?

While I'm here, is there an easy programmatic way to assign arbitrary RGB colors to ActiveX controls? The palettes available from the Properties window are fairly limited. A google search for "ActiveX colors" yields a deluge of marketed products, so it's hard to find useful information.

View 4 Replies View Related

Add Downloaded ActiveX Control To Toolbox

Jun 10, 2008

Version: excel 2003
OS: Win XP

Currently using VBA do develop a tool for Excel. I've downloaded a .ocx control and am wondering how one would go about adding it to the toolbox?

View 3 Replies View Related

Unprotect Form Control Button With Assigned Macro?

Oct 9, 2012

So I have a sheet with a lot of formulas and form control buttons that have been assigned macros.

When I go to protect certain cells and lock them and the activate sheet protection, suddenly my form control buttons with the assigned macros don't work.

I still need to protect some cells with formulas and don't want to leave the whole worksheet unprotected, but in order to allow the form control button macros to run, it appears that's what I have to do....or, is there another way to do this?

View 3 Replies View Related

Replacing Forms Control Combobox With ActiveX

Aug 13, 2014

Since Form Controls comboboxes don't allow font editing, I need to switch to ActiveX...

The combo box values come from the following cell range:

tbl_arrays!$I$3:$I$6

Those values are, from top to bottom: "select distance", "50 Miles", "100 Miles", "150 Miles".

The following macro is also assigned to the combobox:

[Code].....

I have two issues. The first is that the macro doesn't seem to be working. It is supposed to filter a list of cities within 50, 100 and 150 miles of a user input zip or city. The original Forms Control combo works but not ActiveX after I put the code in the change event:

[Code] .........

The second issue is that the last clicked value in the ActiveX comboBox replaces the top one.

Ex: from top to bottom, the combobox should display:

[Code] ........

but if the user clicks "100 Miles", the combobox is then going to display

[Code] ......

If the user then select "50 Miles", the box displays:

[Code] ........

View 4 Replies View Related

ActiveX Click Control--STOPS When On Another Sheet

Nov 23, 2007

RE: Macro ActiveX Click Control--It stops when on another sheet

Macro runs OK when run from menu.

An activeX click button was put on sheet B.

Right click the control, View Code, Paste in code from macro, then click button.

It runs the part of the macro that applies to sheet B, goes to previous sheet A, and then stops. The range select line for the named range on sheet A is highlighted in yellow. It stops when selecting any range or cell on sheet A, like B2.

Any idea why this code does not work on sheet A when ActiveX button is on sheet B? Is there someplace else that the control can go? Using Excel 2000.

See part of code below, which starts on sheet B:

' Macro recorded 11/22/2007

Range("SortAll").Select
Selection.Sort Key1:=Range("T2"), Order1:=xlAscending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
ActiveSheet.Previous.Select
Range("FormBase").Select (STOPS HERE)
Selection.Copy
Range("Formul").Select
ActiveSheet.Paste
ActiveSheet.Next.Select
FormBase is a named dynamic range
FormBase=OFFSET(A!$A$2,0,0,1,MATCH(1E+306,A!$2:$2))

View 9 Replies View Related

VBA / Creating And Attaching New Sub To Newly Created ActiveX Control?

Jun 2, 2014

After programmatically creating a new activex checkbox, I want to create a sub for it's click event. I have given the object a name, and fortunately the code for it's click event is a one-line call of another sub, but how?

The sub would look like the following except be named after the new control (obviously), and yes, it is just the number in the name that changes:

[Code] .........

View 2 Replies View Related

Multiple Instances Of Excel And ActiveX Control Object

Feb 21, 2014

I have an excel application which works extremely well in one single instancec. It has a bunch of ActiveX control objects on the worksheet. Generally I call them by convention Sheet1.Cmd.show.

I have since experimented with having multiple instances of excel running on the machine. I start to notice something very strange. The first instance I open and run all the activeX buttons are all clickable. As soon as I open a second instance of an excel program all the activeX buttons on the worksheet are not even clickable. They are enabled by my program, but not clickable as if they were not there at all.

I also try open a normal excel workbook then followed by my excel program in a second instance. Even though the first excel file does not utilize any activeX objects all my buttons on the subsequent instance are not clickable.

The weird thing is all my activeX control objects on a userforms are still clickable and call to all my planned events in my program. It is just all the activeX controls on my worksheet that do not have any reaction at all.

I always think when one opens a new instance it will be totally indpendent and would even occupy another CPU if my machine has more in it. If they are truly independent then I am at a loss to understand why my activeX controls would fail to work at all.

View 8 Replies View Related

Excel 2007 :: Insert And Link ActiveX Control From VBA

Mar 15, 2012

I have a form that collects four pieces of information from the user and places each into columns A, B, C, D on a sheet. I would like to automatically add an option button to column E so that a user could select it and then click a control button to delete the corresponding row.

Is this possible or is there maybe a better way to do this in Excel 2007.

View 1 Replies View Related

Determine Original Dimensions Of ActiveX Image Control

May 12, 2014

I have a worksheet that contains a number of ActiveX image controls, which have been scaled to a uniform height to serve as thumbnails.

I have also created a class, where each instance is initialized with one of these image controls, and events (specifically the on click event) are captured. When the user clicks the picture, it opens a userform containg the same picture. However, I'd like that picture to be at its original size, not the scaled-down size.

how can I determine the original dimensions of a picture used in an image control? I can tell that the original resolution is there (by changing the PictureSizeMode to clip), but I can't find any properties that show me how big that image actually is, only ones that return or set the size of the object itself.

View 1 Replies View Related

Disable Or Stop ActiveX Control Events Firing

Sep 8, 2006

I've several check boxes on a worksheet. Some of the check boxes control the values of other through the _click event. However, when I try to change the value the event attached to the control in questions fires.

application.enableevents = False

would prevent events being fire from within the macro but this only seems to work when I step through the code.

I understand that I could set a global variable to do this and will probably go down this route anyway - but I am interested to know how/when I should be using the EnableEvent method (as I am sure this should be the way that I use it)

View 9 Replies View Related

Setfocus From Module To Userform Control

Jan 1, 2009

I have a project with many textboxes on different forms. On some of the textbox_exits on some of the forms, I call a standard module that checks what the user has input. If the user needs to change the input, a msgbox appears to inform the user the info needs to be changed.

I have tried to use ControlSource, Name etc., But I cannot seem to setfocus back onto which ever textbox the input needs to be changed. I think it has something to do wih the _exit event, but not sure.

View 4 Replies View Related

Keeping Track Of Which Macro Is In Which Module Since You Can't Rename The Module?

Mar 27, 2009

After all the awesome macros I've obtained with the help of all of you, I now have over 30 macros, each in its own module. I have tried without success to re-name the modules with no luck. How is everyone organizing these?

View 2 Replies View Related

ActiveX Control Text Box Inserted Which Is Not Letting To Fetch The Desirous Result?

Apr 20, 2014

In A1 there is an ActiveX Control Text Box inserted, now in A1 cell which is beneath this text box contain the formula that if A9 is blank than "Customer Name" should appear else it should show blank. But the problem is when I write some thing in this text box which is connected with A9, formula works as "Customer Name" disappears but when I delete in text box it simply acts as if something is still present in cell A9 and formula does not comeback to "Customer Name" again & therefore in order to appear "Customer Name" I have to go to A9 and press delete button to get the desirous result from the formula.

Readers are requested to make this formula work becz the situation in which this formula has been invented is well fitted and not other formula can supplant it.

View 1 Replies View Related

Macro For Form Control Button To Reset Scroll Bars To Static Column Of Numbers

May 8, 2014

I have never written or used a macro before and I have a simple macro task to complete:

I have Column L (L4:L10) of seven scroll bars that move according to number changes in column F (F4:F10). I want to create a form control command button that resets the changes on the scroll bars according to static column of numbers in Column E (E4:E10).

I don't know if it matters, but I'll add that I plan to add a second button that does the same thing with a different column of data. I assume I'll simply replicate whatever procedure I use in the first button - is this okay?

View 1 Replies View Related

ActiveX Command Button Text Looks Bad

Aug 12, 2009

I have created an ActiveX command button and the text on the button looks crude. I know that is not very descriptive but I am unsure how to describe it. The text looks jagged and some letters are missing chunks of their letters. The font I have chosen is Calibri.

If I create a Form Controls button I do not have this problem but I want the button to have a particular background color so I do not believe I can use a Form Controls button.

I do not know why the other Calibri text on the worksheet looks fine while the ActiveX Calibri text does not. The attached image shows the two buttons with the top one being the ActiveX button while the bottom is a Forms button.

View 11 Replies View Related

Reference ActiveX Button Which Has Been Clicked?

Mar 19, 2013

Is there a way in VBA to reference the activeX button which has been clicked? Like a ThisWorkbook equivalent for a button?

I have quite a few button whereby they set a parameter for a procedure 'TrendData' based on the row they sit in. Currently I just have the row number hard coded i.e. Call TrendData(5) but I want to amend this so that when I add a row it doesn't offset all my buttons.

For Example

Call TrendData(CommandButton3.TopLeftCell.Row)

However instead of typing CommandButton3, CommandButton4, etc. I would like the code to know which button had been clicked and just use that?

View 9 Replies View Related

Centering Text On ActiveX Button?

Apr 2, 2014

I have searched high and low and cannot seem to find an answer. I have inserted an ActiveX button in a cell to run 3 macros when pressed. I cannot get the 4-letter name on the button to appear centered on the button, unless I make the button larger than the cell, which I do not want to do.

View 4 Replies View Related

ActiveX Option Button On Click Formatting?

Feb 26, 2013

I'm running into an issue with my ActiveX Option Buttons where they change appearance on click, rendering my transparent settings moot.

Here is an example of the process flow where a user decides to select 'New Visits' instead of 'All Visits':

Before click
before_zps37d416b4.png

After click
after_zps0e12e3e6.png

Here are the properties of the buttons:
properties_zps84fcff45.png

Is it possible to avoid this scenario?

View 1 Replies View Related

ActiveX Toggle Button Changes Cell Color?

Oct 5, 2012

I am creating a status board at work... Kinda like an In/out board.

I created a toggle button and using it as the persons named. I want them to be able to go to the excel sheet on our intranet. Be able to click their name (toggle button) and it change the off cell from red to white and the on cell from white to green. Then they can save the excel sheet and close out for the next person.

edit: I would also need it to go back once they click it when they leave.

I have created the active x button, but so far the only thing I can do is get the 1 cell it effects to say true/false.

View 9 Replies View Related

Disable Command Button (ActiveX) Until Next Day Once Pressed

Aug 26, 2013

I have made an excel workbook detailing team performance that all of my team have access to and that requires updating once a day. The first person to access the workbook each day presses a Command Button that updates the workbook and inserts a time/date stamp. However, other members of the team go into the workbook and update it again the same day which then affects the data being reported.

I know i should probably just sack them for not being able to read the time and date but HR would not like that so is there a way to disable CommandButton1 (ActiveX) so that once it is pressed it is disables until the next day?

View 3 Replies View Related

Hiding ActiveX Button When Hide Columns

Apr 16, 2014

I am putting several buttons into my spread sheet and would prefer to use ActiveX controls rather than form controls. But I also need to hide the buttons from the end user (controls are to update data and will be used by the person who maintains the workbook). When I go to hide the columns, the ActiveX button doesn't hide with it. On the other hand, if I use a Form Control Button instead, it does indeed disappear when I hide the columns. Is there any way to get the ActiveX button to hide when hiding the columns?

View 9 Replies View Related

Make Invisible Activex Command Button In Selection

Dec 30, 2009

I designed my spreadsheet incorrect.

Everything works good. But when I selecting tables with listbox, I forgot to notice that there also comboboxes.

I mean, rwgrietveld, I use selecting table to hide 'em, but when I hide 'em comboxes should also disappear (become invisible).

is it possible at all to make invisible activex commandbutton in selection?

View 11 Replies View Related

Command Button For Sub In Module

Jan 28, 2012

I have 2 Subs in Module 1

I want to link them to a button

When I create a "ActiveX Command Button" it is only links to the worksheet (say Sheet1)

I have tired changing the name below to the Sub in the module but doesn't work.

Private Sub CommandButton1_Click()
End Sub

View 3 Replies View Related

Form Or ActiveX Button To Stop / Start Code Temporarily?

May 12, 2014

I would like to know the easiest way to temporarily keep a worksheet code from running while I am editing, then turn it back on when I am done. I was thinking a button with these commands(?)>

Application.ScreenUpdating = False

Application.EnableEvents = True

but I don't know which button to use, or if I would need a button for each.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved