command

I am trying to write a do if loop command that takes a look at data in 3 different columns and then outputs a value to a 4th column (F in the command). When I run this command, Excel stops responding, I have even left my computer for a few hours and still not responding, please help with what...

Hi please can you help I have a command button1 with s list for example: shop, car, home. If home is selected then what I type into the text box I want this copied into sheet2 A2:A5. If car is selected I want the text in the textbox copied into sheet2 B2:B5 hope this makes sense please can you...

In a excel workbook I had written a long VBA project consisting of many forms (with their code) and various modules of sub codes. All this matter was stored in PERSONAL.XLB file and a command was set in the ribbon for rapid process activation. I made many copies with different names and...

Hi all, I have made a command button that gives me a MsgBox of the active cells interior colorindex, I notice the default is -4142. When I make a cell yellow for example the command button returns 6 Now if I were to make the cell yellow using conditional formatting then test the command...

Hello, looking for a little help with this code, Private Sub CommandButton2_Click() Application.ActiveWorkbook.SaveAs "C:\Users\andy_\OneDrive\Desktop\VAMLog" & Range("G5") & "-" & "OP" & TextBox5.Text SourceWB.VBProject.VBComponents("SAVEPDF").Export "SAVEPDF.frm"...

Hi Folks, i am look for a code to add to command button that will copy the active worksheet into the same workbook Every time i click the command button its copies an additional page any help appreciated

Trying to toggle an image on a command button for sort direction. I keep getting a type mismatch. currentPath = ActiveWorkook.Path cmdSort.Picture = currentPath & "\sortAsc.gif" Double checked the file name just to be sure.

Hello All, First time poster here - maybe there will be a kind soul that can help me with this strange issue. I was attempting to create a command button to display a userform for a project I'm working on, but was getting some strange behavior out of the button that I couldn't figure out...

Hello All, First time poster here - maybe there will be a kind soul that can help me with this strange issue. I was attempting to create a command button to display a userform for a project I'm working on, but was getting some strange behavior out of the button that I couldn't figure out...

Hello, Need help in the below code. I am calling a command button sub procedure using the loop. When I did it without loop I used Sheet3.CommandButton3_Click and it worked fine. But, then I am doing it using loop then I change it to ActiveSheet.CommandButton3_Click which is throwing error...

hello everyone, tried doing with dax and regular excel methods but scratching my head here is a table example. the "style" number is repeated because there are multiple vendors that source the product. i simply want to concatenate each of the vendor names together separated by a comma. how...

Long time that I played with the Shell command. I keep getting Error 5. I think that it is related to some space included in the path, but can't find how to resolved that yet. The goal, start and external application when my Excel file is opened. Private Sub Workbook_Open() ' Setting a...

I've written a macro that takes the User to a web site; unfortunately it opens in less than full screen. Is there a macro command to expand to full screen ? TonyGreyHd

How can I accomplish closing an Excel workbook and it's except window completely. But I don't want it to close the entire application unless it is the only one left open! So in a lot of cases, I have a lot of Excel books open. So using the application (.) Quit command cannot be used because it...

Hello All, I have one userform and I am adding textbox and commandbuttons dynamically to it. Now I want to embed not link a picture on one command button so that picture appears on command button even if picture file is not in its location. I tried creating one userform and adding picture to...

Hello, Let me start by saying that I am very new to VBA coding, so I'm sure I am making a simple mistake. I found similar questions to this on the forum, but none had exactly what I'm looking for. I have a document that is updated daily to track certain progress in my work team. I have...

hello, I have an excel book i created to track inventory. The book has a sheet with a list of users (A), their initials (B) and a password(C). I have placed multiple command buttons on certain sheets that each run a different macro. What i would like is a way for users to be able to log in and...

Hi I am designing a calendar with 365 command button as 365 days, and all buttons has same codes in spite of indexes. Is there any way to have one procedure instead of 365. for example my first day on seventh month procedure is here: Private Sub day_7_1_Click() For i = 1 To Sheets.Count If...

So has there been a recent Excel update that would cause the vba code saying "Load frmFormName" to now cause this error: "Run-time error '380': Could not set the List property. Invalid property value." Using this same command worked for 2 years, and now all of the sudden it fails... any help...

I have a sheet of data and in 'column Q' I have the following command in each cell (example below for cell Q2): =WEEKNUM(O2) & TEXT(O2, "-yy") This displays the week and year of the date in 'column O' i.e. 2-19 or 32-18 etc I then have a pivot that reports on the number of tickets created by...