control

When I try to use the "find" box it appears, rather large and with the buttons off screen, to the right. So far I have been unable to find how to control it - can anyone help, please?

Hi Everyone, I have a document thats going to go out to over 200 people. I have set it up with loads of macros stopping anyone from editing, changing and playing around with it, however there is still the possability that someone might think they know what they are doing and change things as...

Hello, A field in my database is for a control number. The control number varies in length, from 16-20 alphanumeric characters. That control number always* ends in 6 numbers, which I extract and copy to the clipboard using VBA. *On rare occasion, an alpha character (always an alpha...

Can somebody tell me how to get the calender control in the UserForm? I don't find it in my additional tools

Hi, I'm trying to control keyboard with VBA using sendkeys within Vmware Horizon Client remote software. I managed to control the window of the remote software but i did not managed to write something with sendkeys . can you tell me if the function sendkeys is authorized with Vmware...

The control source for a textbox on my form is =[cboAcronyms].[column](2) It stopped working; i.e., it's not pulling values from the 3rd column of the table that's the row source of [cboAcronyms]. It's worked in the past, and the only modification to the table was that I added a new row of...

Hello, I have a userform that I am trying to insert the small calendar into. I believe the proper control name is Microsoft Outlook Date Control. When I select this in Additional Control it then appears in the toolbox. Good. However when I then click it and try to place on the userform in get...

When you go to create a Macro, based on an Event, there is a selection for "Requery" When you select that it comes up with a filed below it titled "Control Name". It appears that it wants the user to enter some kind of information. What is the Control Name and what kind of information/data is...

Hi Is there a simpleway to update my Ribbon Editboxes from cell updates during runtime. I can seesimple ways to populate editbox when opening a Workbook, and updating a cellfrom the Ribbon Editbox during runtime. I cannot see a way to update the ribboneditbox on cell change? All...

What is Alternate method to change Focus from TextBox to another Control whose following properties are Textbox1.EnterKeyBehaviour = True Textbox1.MultiLine = True Following does not Trigger to set focus on another control Private Sub Textbox1_KeyPress(ByVal KeyAscii As...

Hi, In .xlam file I have added UserForm which initialize by set position of the form in middle on main screen with dual monitors. I am using it commonly in all other forms in xls/xlsm. Me.StartUpPosition = 0 Me.Left = Application.Left + (0.5 * Application.Width) - (0.5 * Me.Width) Me.Top =...

I have been searching the internet for hours and I cannot seem to find a clear method for the following. I would like to have several macros listed in a list box that when selected will run. I currently have a bunch of form control buttons on my sheets and it's getting messy. I am able to do...

Hi, I have a form control button called "Hide Col" that runs the code below. I would like to make the button toggle to hide and unhide. I tried to implement some code that I searched online but I'm unable to do it correctly. Also, I see it's possible to have the control button name change as...

Hi all, I have created a User From to manage the batch acceptance of stock in my workplace. When a new product is received the expiry date is logged...I have set the cells (using conditional formatting) to go red once the product has expired and to go yellow when the product is within 30 days...

Good morning! My apologies for the somewhat cryptic Title but I was unsure just how to phrase this This macro saves a version of a file in a specific folder and names it filename - version - extension The version is incremented each time a change is saved. The new versions are saved with...

I have a spreadsheet that copies and pastes a signature that is stored on another sheet to the main sheet. The workbook will be protected and I wanted a way for users to update the signatures. I was thinking to add some kind of a control that would allow me to press a button and select a file...

Good morning! I am wondering if there is an easy way to make 6 macro control buttons all the same size. I have the drawing toolbar enabled and have used the Align and Snap options but would like to find a way to make them a uniform size if at all possible for aesthetic reasons. I appreciate any...

Hi All, I have a large spreadsheet in which the data changes on a monthly basis, each month i need to go through all the rows and find any that are not equal to "0". Unfortunately it is not as simple as applying a filter as there a lot of formatting issues (Which i do not control). Currently...

Hi Is it possible to have a callback for the ribbon when a key is pressed, rather than when they press 'tab' or 'enter' - for a dynamic search? Also, is it possible within VBA to set focus on a Ribbon Control? E.g. after the macro has executed, to go back to the text box in the ribbon? Thanks...

Let's say I select a control to add. I click on the form and it adds it. Now I want to add another control of the same kind. I have to go back to the toolbox and select the same control again, every time I add it. This is the default. There have been times when it adds that same control...