command

I have an asset list of 200+ items. I would like to add photos of each asset to its row. So far I have this command button vba Private Sub AddPicture_Click() Dim strFileName As String Dim objPic As Picture Dim rngDest As Range strFileName = Application.GetOpenFilename( _...

Hey good folk, I have a timesheet i get my engineering dept to fill in, we have a lot of customers who's name they have to input when working on a design. The "short" name our ERP system uses is noting like the actual customer name and my guys sometimes get confused. Anyway i have created an x...

Hi all, In the folder "A" (folder address: \\address1\A) we have some pdf files like below test1.pdf test2.pdf test3.pdf Someone came to here and signed some of the pdf files and save it as (lets assume test1.pdf was signed) adding "signed" to the end of the name. So we have now following...

I have a folder with many pictures named as number.jpg (ex: 100152.jpg, 100153.jpg). I don't want to copy everything in this folder— only the files with the exact name as the names in a txt file that I have created. I am using this in the prompt. However, all pictures from SourceFolder are...

Hi everyone, I am new on here and have a small problem. I want a command button to copy a range of cells and past somewhere else on the sheet. Simple enough I know, but if I have range("A1:A10") no problem, but I want range(A1:A&H1). I know this won't work, but I want the value to change to...

On: Sheets("Players") I have a command button, when clicked this runs: Private Sub CommandButton1_Click() Dim Player1 As Variant Player1 = InputBox("Enter Player 1") ActiveSheet.OLEObjects(1).Object.Caption = Player1 ActiveSheet.OLEObjects(1).Object.BackColor = 49152 End Sub On...

Hi, Can anyone help point me in the right direction to run the code Import_SOR_Data1 by selecting a command button in the ribbon? How to create the command button please? Also not sure if the macro is in correct place in the linked form Regards, Wayne Copy of VOID VALIDATION KCxllinestyle.xlsm

Hi all, I want to reset both my data validation dropdowns and manual entry cells with a single click of the Command Button. I already have the code for the dropdowns from a previous thread, what Macro/VBA should I enter to reset all manual entry cells to blank, and how do I combine the two to a...

Hi, Please can someone help me? I would like my commandbutton1 caption to show what is selected in my listbox1. Any help would be appreciated. Thanks Dan

Hi, I am creating an Userform with several command buttons on it. Is there a way to batch rename them as : cbButton1 cbButton2 cbButton3 cbButton4 cbButton5 … ? Note: I hope to give new names to them. not to change their captions. The way I am using now, is simply click on them 1-by-1, and...

I have 10 command buttons named cbTC#. The code below works good, however Is there a better way to code this without having to write the code below 10x (1 for each command button)? Thanks Private Sub cbTC1_Click()If Len(tbx800) > 0 Then If MsgBox("Do you want to delete data?", vbYesNo) =...

Just wondering if I can shorten my code a tad by changing grouped buttons with 1 command instead of two. For example: If you have a group of two radio buttons (for this example I'll call the group "NewEmp") and you want to lock or unlock them, do you have to use two commands (i.e...

<ytd-expander id="expander" class="expander-exp style-scope ytd-comment-renderer" style="display: block; --ytd-expander-button-margin:4px 0 0 0; --ytd-expander-collapsed-height:80px;"><yt-formatted-string id="content-text" slot="content" split-lines="" class="style-scope ytd-comment-renderer"...

Hello I am fairly new to VBA and i am looking to create a tabel without having someone enter duplicate records over and over by hitting the AddReturn button over and over. below is what i am using for the command button. Any Idead what i should add to stop this? Private Sub AddReturn_Click()...

Hi there! I have some problem and I will wonder if you help me on this. I have a calendar with 12 command buttons with name month_1, month_2 , ... ,month_12 and almost 365 command buttons with name day_1_1, day_1_2, ... ,day_12_29 and also 365 cells in a separate worksheet relative to this...

Hi experts, I have a long list of data exported into excel from a text file. This file contains output of a command from multiple network elements. Whenever there is a text string 'Welcome to', the below mentioned text should be copied to a new column till the next 'Welcome to' appears. In this...

Hello, This is my first post. I've tried searching this out without success. Probably because my VB skills are non-existent. Anyway, what I'm trying to accomplish is, I have a userform with a command button on sheet5. When the button is executed, I would like index/match sheet5 column A against...

I have a form with a listbox. The form is set up so that I type entries into a series of text- and comboboxes, and then press a command button to add the values into the listbox (see picture...

Hey all. Need help on my project. So, I have 2 sheets. Sheet 1 is where the 2 Spin Button and a Command Button is located. Sheet 2 is where the data get recorded. Basically, what the Spin button does is to count each click. I already have the code for this. The Command button will add a new...

Hi All, having an issue with my code and hoping someone can help. I have a workbook that has 2 sheets, 1 is the master data sheet the other is the active sheet "Allowed repair" with 2 buttons, search and clear contents. I have set the command button to execute the following VBA macro in a...