VBA training - create button

I have a list of about 10,000 odd training records and I need to find, for each of the approx 300 course codes, the earliest and latest dates the course has been run.

Columns of data a

Course Code
Course Name
Start Date
Finish Date
User name

So for each of the 300 course codes, I need to get the earliest Start Date and the latest Finish Date.

I'm familiar with Max/Min functions, Named Ranges and how to find the unique Course Codes from the list. But not so sure about how to set up a formula to find the records for one course code against which I can apply the max/min function.

Any help would be appreciated.

Ward
in Perth

Hi everyone,

I just wanted to give you a heads up about Dunamis Training, LLC. We are dedicated solely to Excel/Access VBA programming. If you are interested in having a 2 day VBA class at your site or come to an offsite class, contact us. We are in the Pittsburgh area! Our instructors have decades of proven experience in VBA solutions at companies like FedEx and GM. We target business professionals, so you don't have to be a programming expert to participate.

Check out our web site: dunamistraining.com

If you have any questions, shoot them to us from our website "contact us", or call us. Thanks.

Chad Marinelli
Owner/Trainer
Dunamis Training, LLC
1-412-628-9464
chad@dunamistraining.com

I am doing work on a linear regression and the graduate student that is reviewing my work wants me to create a number of worksheets that have a randon sample of the data- say 60% of the rows. Then we fit our model to these different worksheets. Is there such a function or do I need code of some sort?

I am just beginning to learn how to make macros but I need help in a big way. what I need is a macro that will figure out how to schedule people for training based off their schedule and available training classes. I.e. i have a list of dates, times and number of people that can attend. I need something that would base the persons schedule on the available time and assign the class, then when it maxes the class out it moves to the next class. I know it is a lot to ask for but i am in desperate need for some help.

Hello

I have set up a userform in Excel. I have then created a macro to open up the userform. Then I added an icon to run the macro. Everything works fine. However, when I close the file, the icon disappears.

Is there something in my settings or Excel options that I need to change?


Any help would be great


Thanks

Hi
I want to create a new button and use the text on this button to go to a sheet that have the same name than the button text.I add a user and never know the name at the beginning.The sub will be go_to_sheet so i will go to this user sheet.

Thanks for your help
Remi

Sub Add_user()
arret = 0
'userform2 is to register the user name
Load UserForm2
UserForm2.Show
add_sheet
Sheets("begin").Select
End Sub

Sub confirmation_Click()
user = Txtnom
End Sub

Sub Add_sheet()

If stop = 0 Then
Sheets("2").Select
Sheets.Add
ActiveSheet.Name = user
Range("A1").Select
Sheets("Master").Select
Cells.Select
Selection.Copy
Sheets(user).Select
ActiveSheet.Paste
Range("c3") = user
Range("A1").Select
add_button
End If
End Sub

Sub add_button()
Sheets("begin").Select
ActiveSheet.Shapes("Button 1").Select
Selection.Copy
x = ((Sheets.Count - 5) * 3) + 3
Range("K" & x).Select
ActiveSheet.Paste
Selection.Name = user
Range("K" & x + 1) = user
Selection.Characters.Text = user
Selection.OnAction = "go_to_sheet"
Range("H13").Select
End Sub

So I've got Sheet 1 with say

____A___B___C
1___m___i___c
2___r___o___s
3___o___f___t

I would like to create a button that can create a new sheet and paste A1 to C3 at the same location on the new sheet

and I need this to create a new sheet and do that everytime the button is pressed

can someone help me with this?




I've tried creating a shape and assigning a recorded macro to it where i did this:
1. create a new sheet (this part worked)
2. copy data (this worked)
3. pasted onto new sheet (did NOT work, instead it kept pasting onto the same sheet and 2 lines below the older version)

Hi, how can I delete an activeX button, listbox and textbox when I close the workbook and create this controls again when I open the workbook?

I have some buttons in my worksheet.And all those buttons will do the same action. Since I will also dynamically create even more buttons using VBA during runtime, is there any way to create the actions for them without typing for example "Private Sub Line15_Click() SendData (15)" manually? I mean I want to add the action to the button at the same time the button is created.

Thank you~~~

The example of the current button action is as below.
Code:

Private Sub Line15_Click()
    SendData (15)
 
End Sub
Private Sub Line16_Click()
    SendData (16)
 
End Sub
Private Sub Line17_Click()
    SendData (17)
 
End Sub
Private Sub Line18_Click()
    SendData (18)

Yours sincerely,
lolo

Has anyone created a macro to create a forms button, assign a macro and name the button? Any info would be appreciated.