control

Apologies for the lengthy title. I have never done anything using a check box. What needs to be accomplished is when the check box is selected all the data that is in the userform will be copied and redirected to a worksheet. Currently when the command button is selected it copies all the data...

I have a workbook that opens another workbook. Can I control the caption on a label using a separate workbook that is running all my code? Below is my code... but I have an error in the last line. Private Sub CommandButton1_Click() Dim Wbk1 As Workbook Dim Pth1 As String Dim...

I'm using this line of code to add 12 empty rows at the top of a worksheet Var_RawData_Worksheet.Rows("1:12").Insert shift:=xlShiftDown I'd like to use a variable to control the number of rows but can't figure out the syntax, what I need is something like: VARIABLE_NO = 12...

Sub D_W() Dim X As Range, Y As Range For Each X In Range("B3:g3") Set Y = Range("J5:Q10").Find(X, LookIn:=xlValues, lookat:=xlWhole) If Not Y Is Nothing Then Y.Interior.ColorIndex = 6...

Hello everyone, I have a macro that I wrote that duplicates a selected range at some position in my worksheet. The position is selected based on informations given by the user through an UserForm's ListBox. This macro works well and I would now like to determine its runtime depending on the...

Hi all, same kind of issue as a few days ago.. NewIndate = Format(DateValue(InDate.Caption), "dd/mm/yyyy")NewOutdate = Format(DateValue(OutDate.Caption), "dd/mm/yyyy") If NewIndate = "" And NewOutdate = "" Then MsgBox "Please ensure you have entered a date or date range in the Control...

Hello everyone, So, yeah, the question is in the title. Can I for instance write something like Private Sub UserForm_Initialize(rowCount As Integer) and call it in my macro with myControl.UserForm_Initialize(rowCount) and expect it to work ? Thanks you for reading, Marie

Seems like a simple but I can't get it done. Tried a User Form with a Control Button: can't get it to overlay om my Worksheet.

Hi Guys, I'd like to change the line spacing between items in a VBA listbox. Let's assume I display month names in a listbox control. Name of my listbox is "Lista". It's easy, I just add one line to "Private Sub UserForm_Initialize" for the userform: Lista.List = Array("January", "February"...

Hello, I'm trying to control various labels on a Userform. Some of the things I want control: Change color of a button based on whether it has been clicked Is it possible to make a button visible or invisible by a macro? I have tried to use the following to accomplish this: Label56.visible...

This is going to be long and tedious, or I am just simple minded. I would like to have a database of information (Control) on one sheet, and import data on another sheet, and have a formula compare that to the control and if it finds a similarity I need it to tell me how much money is invovled...

I need help creating a control button on my worksheet named 'Data Validation'. That will open a Userform named 'AdjustResetButtonForm' containing the follow code: TextBox1.Value = Sheets("Data Validation").Range("X3").Value TextBox2.Value = Sheets("Data Validation").Range("X4").Value...

Good day, I have a userform with 31 image controls (on for each day of the month of May) which populate with pictures from a folder that are all contain dates (again in May) in the name. I then extract the date from the filename and find the correct image control to place it in. The code...

i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture

Hello Kings of excel i have 4 sheets each sheet has a Filters with data i want to combine this sheets in one Worksheet so i can control & modified them easy without getting to them Exemple like in the picture

Hi all. I have a worksheet that contains 8 sheets, 6 data sheets(data 1, data 2 etc), 1 control sheet and a combined sheet. I'm trying to combine the data sheets into the "combined" sheet and exclude the info on the control sheet. each data sheet is setup identical with headers in cells B2:K2...

Hi All Hopefully someone can point me in the right direction with this problem. We are trying to get away from having paper copies and go digital with batch cards at my work. At the end of each week we print out a weeks worth of batch cards, the operators use the cards for recording...

Hi, I have a list of image file names (minus the extensions) in column A and an Image ActiveX control embedded on Sheet1. Could you help me with a code that would access and display the images? For instance, when a cell in column A containing "Image1" is selected, Excel should access...

Hi, Expert I am new in a Excel. I went to get you expert solution for creating a VBA. I Can not Find "Microsoft Date & Time Picker Control 6.0 I Find only Microsoft Outlook Date Control. But Do not work it. Please help.

Hi all, I'm trying to programmatically create a page and a textbox within a Multipage control and I am receiving the following error - "Run-time error '13': Type mismatch The code is as follows: Private Sub btnReset_Click() Dim pagNew As Page Set pagNew =...