userforms

Hi all, I'm building a userform, and I want to include application.username in label1.caption I tried several codes but none has succeeded to show the username, I believe the most logic thing to do is to load the label caption when the userform loads, using this code, but it didn't work...

Intro: I volunteer with a bunch of mature people (old guys) that refurb old PC's and give them to needy families at no cost in our area. What I am trying to do is create a simple time tracking system based on a excel 2010 spreadsheet utilizing userforms. The ws looks like this: date, name...

Same old song and dance-I'm new to VBA, and new to the forum, so bear with me. I have a tendency to be long winded, so I'll try to keep it simple. I've built a userform that has checkboxes on the second tab. I want the user to be able to check a box and have that populate blanks in a textbox...

Hello, I have been slowly learning VBA language and macros, and built my first user form yesterday. I was able to successfully get the form to open via a button, clear entry, close the form, and produce an error message when the form isn't completely filled out. However, the final and most...

I appologize if this has been discussed elsewhere, I did a quick search on here and didn't come back with anything that suits my needs. Moreover, I've also searched google as well. I just started using Userforms today. I've used Visual Basic before so I understand some about the theory about...

Hi I am new to VBA and would like assistance in completing my code below. I am trying to create a spreadsheet on Customers and the first form would allow user too input new customer and I would also like to build from this a form and code to allow user to 'Edit' customer information. Any and all...

Hi, I have 24 macros that each execute two web queries, pull the data into a sheet, do some fancy manipulation and then put some values into another worksheet to display for me. Each macro calls the next until the last macro. These executions can take some time to complete and so I was...

Hi I have 1 main userform and I need to open another userform using a command button from within that 1st form. The 2nd userform appear right in front of the 1st userform. When the 2nd userform is closed either via VBA or clicking on X, it closes both forms. Does anyone know why this happens...

I am at a loss for how to do this. My current code is simple and displays data only for the latest checked box: Private Sub ComboBox1_Change() End Sub Private Sub CheckBox1_Change() Me.ListBox1.RowSource = "Sheet2!A22:A32" End Sub Private Sub CheckBox2_Change() Me.ListBox1.RowSource =...

Hello all, I have a question regarding some commandbuttons and userforms. I have a list of clients in Col A and Col B,C,D all contain relevant data to the client. I want to set up three different command buttons on my master spreadsheet (Add new client, Edit existing client, delete client). I...

Hi, This is a two part question that I would reallyappreciate help with. The first time I used this code it worked but then stopped does anyone know why this might be? Private Sub StructureDiv_Change() If Len(txtCostCentre.Text) = 3 Then Label16.Caption = Application.WorksheetFunction. _...

Morning! Relatively new to userforms in vba, but I have managed to create a form that controls users input of data into an excel database. I have called this an 'Add New data' function. Now I would like to have an 'Edit Excisting Data' and 'Delete excisting Data' Function. I have studied some...

Hi, I've been using Mr Excel for long period now, but this is my first post. Greetings. Is there a way to reference the controller that trigerred a subroutine?? like the ME or ThisWorkbook, but for controllers on userforms. Thanks for the help

Hello, Sorry first off if the title of my question is a little confusing. Firstly if i explain what i have created so far it may be easier to understand. I have created a workbook from which a userform is enabled, this userform allows people to submit information to a secondary workbook on...

Hi everyone, I have a bunch of forms in memory as part of UserForms collocation. I find the particular form that I want to unload from memory through a "for each" loop, but I fail to do so successfully. Could anyone suggest a correct syntax? Many thanks in advance Public myForm As...

Hi there, I have a list box 1 and a spin button, and a list box 2. When the user selects an item in list box 1, and presses the spin button the item will go to listbox 2. Anyone have any advice on how to do this programattically? Or a link they could refer me to...

Hi I'll try and word this correctly....I am creating a user form where all entries (using a command button) are placed in specific cells on the worksheet. So for example if I enter on the 01/10/2011 I spent €10 on clothing, I want the data to be placed in the worksheet adjacent to the row with...

Hi, I have a workbook with several non-modal userforms. When I switch to another workbook, the userforms are still visible. Therefore, I want to hide all userforms if the current workbook is deactivated. I tried to loop through all user forms and hide them, but I can't manage to loop through...

The title should give a fair overview of the problem but I'm running a dynamic named range for use in a combo box in a userform. When I run the form, the values appear as intended. When I call a module sub-routine via a command button, the values don't appear and I've no idea why. The dynamic...

Hi All, im kinda newish to VB/VBA (used to be good but many years ago). anyways my delema is as follows; I have a program made in vba for the office for different users on different computers to use. There is 1 form that I want to only appear the first time they run the program each day (the...