command

I have a user form with twelve command buttons on 8, 12, 14, 16 etc up to 30. Now I have 12 workbooks I wish to attach to each Command Button. Try as I might I cannot attach the workbook to the command button. If I can get one to connect when pressed then I can just copy the code for all the...

Hey guys, I'm trying to get the average of an array(no empty values) i have. I'm trying to do something like: averageMonth = Application.WorksheetFunction.Average(AryNoBlanks) And i get the error: 1004 unable to get the average property of the worksheetfunction class Am i just miss-using...

Hi, I was wondering how can I open a specific worksheet using VBA code on a command button macro? When then user accesses my "Welcome Sheet" worksheet and clicks on the command button "Students" this should bring them to the "Students" worksheet. I tried the following code but I got an...

Hi, I was wondering how can I open a specific worksheet using VBA code on a command button macro? I tried the following code but it doesn't work. Private Sub CommandButton_2Click() Worksheets("Students").Activate

I presently have a lengthy document that has titles, in an Index, at the beginning of the document. How can I use command buttons with each subject so that when selected , it brings the reader to a specific row in the document? Person selects the "HR" Command Button - it brings the person to...

Hi all, I need some guidance and how to improve VBA code. Currently, I'm using the following command to find a part number "PN" within a range (B2:C5000). Worksheets("Data_Base").range("B2:C5000").Find(What:=PN).Select The problem is that as the parts list gets bigger the formula wont find...

Hi all, I need some guidance and how to improve VBA code. Currently, I'm using the following command to find a part number "PN" within a range (B2:C5000). Worksheets("Data_Base").range("B2:C5000").Find(What:=PN).Select The problem is that as the parts list gets bigger the formula wont find...

Hi I have two values in non adjacent cells (C4 and J4) that I wish to swap between them by clicking a single command button, and that can be done any number of times needed. I know how to insert a command button but I really don't know VBA coding. I googled my problem but I can't manage to find...

First of all like to say Hello to everyone i am a new here so please be patient with me LOL and at 67 takes a little longer for things to sink in ;) i have just done a sign in sheet for work staff and i have a command button that puts in the date and time of start of shift and the same for...

I have a bunch of command buttons in a workbook. I wrote the workbook vba coding on a machine with a 4k display and Excel 16 and the 1st user-machine (Eventually to be 40) are using colder machines with 4:3 screens and excel 2010. Subsequently, the buttons are changing sizes/positions when...

Hello. I am using using VBA to create a VB script file that will create folders and copy files. Everything was running great until I tried to use the MkDir command. Here is the VBA Command followed by how it appears in the VB script. macfile.Write (" MkDir(""" & dest & "\" & stk & "_" &...

I have a macro that clears all of the cells in a workbook before I repopulate them with new data. The first step in the macro clears all of the Command Button captions. I then do an Application.Screenupdating=True I then carry on to clear all other cells. As these are being cleared they appear...

Can any one help me please? I want to, When I click userform command button8 then userform image2 show me picture from worksheet ("Client profile") picture6:( please help me.........

I have a query relating to sorting in Excel that has me stumped at the moment. I have a table with five Command Buttons in Column A. In the columns B - E is the data. When I select Column A - E and try to sort, on Column C for example, the data sorts as expected but the Command Buttons in...

So my command buttons all work properly, however, they all seemed to have shifted a column or two to the left. When I click the button, it will briefly appear in a different location and not execute. I have to open the code and manually run the command. it is consistent across multiple files...

Hi I'm developing a game in Excel. I have two hidden buttons for "yes" or "no" answers which become visible when a shape is clicked. However, when they do become .visible=msotrue they don't work. Yet if I click another command button that has always been visible, they both become active...

I have a summary userformwith 2 DTPickers and 12 picture frames. When the user selects datesand clicks on a command button (Update Graphs), a graphing macro updates allthe graphs (*no problem with the graphing macro so will leave out*). Thistakes a couple seconds so I thought it'd be fun to...

Have 10 command buttons and a text box. When I enter a value in textbox1 i want to show that number of command buttons E.g if I enter 0, no command buttons will appear, if I enter 4, command buttons 1,2 ,3 and 4 will be visible and the others won't be. Thanks

How can I create a transparent Command Button? I would like to have 50 or so Command Buttons overlaying cells in a worksheet such that the contents of the cells will show through the command button.

I have a spreadsheet that we use quite often, and am trying to make it a little more "user-friendly". So, to facilitate rapid-resuage, I inserted a Command Button (ActiveX Control), named it "Reset Form, and have this as the code: Private Sub CommandButton1_Click() Range("C3").ClearContents...