vba & add

Hello, I like to create a vba code that will fill in the date and time when you press it into another sheet. I wanne create one dashboard with buttons that will fill in the date in different sheets. This i what i already found but this will fill it in the same sheet and cannot find how to...

Hi; I have a login form where the password is displayed with * How can I display the password using the checkbox?

The code below just loops through files and then sends them. But the MSGBox keeps appearing after I`ve send the Email? And the code will not end? Also it produces a email for each file type all file types if finds needs all be in the same Email. Sub Send_Email(EmailTo As String, EmailCC As...

Hi; I am asking you and my dear friends and professors to help me I have two sheets in the attached file One sheet to enter and edit information and another sheet to store information I encountered a problem editing information in this file I cannot recall and edit the information I have...

I'm seeking assistance in creating a VBA macro that can help me merge data from multiple workbooks located in different folders based on order numbers in another excel file. I am beginner and not having enough knowledge in VBA. It would be a kind help to achieve my migration activity. Here's...

Hi; In a user form, we have 6 ComboBox and the value of all of them is the same Is it possible to assign a value to all of them with a loop? And by selecting an item in any of the combo boxes, that item will not be displayed in other ComboBox

Hello In an Excel file that has several sheets, there is a ComboBox in each of the sheets. I created a sheet list with the code below Private Sub Worksheet_Activate() ComboBox1.Clear For wsheet = 1 To Sheets.Count ComboBox1.AddItem Sheets(wsheet).Name Next End Sub By selecting the...

Hi All, This is my first post so go easy on me, also let me know if I am posting wrong. I found an old thread relating to this topic that included a code however there is one change that I would like to make and my coding knowledge isn't advanced enough to figure it out. I am trying to have a...

Hi, I have a question that I would like to ask you my good friends Is it possible to display a help text when the mouse pointer is placed on the button?

Hi, How can I create a listbox in the userform? that when I was in any sheet, it would show me the information of the same sheet.

Hi. I found this on contextures and it creates monthly workbook with separate daily blank sheets and date as the tabname. How do I change it to copy a template sheet instead of creating blank sheets? Also, to add the code to change merged cell of A2:J2 to the date created each day as "DD MMM...

Hello dear friends, don't be bored I was looking for an article about creating a minimizer on the Excel user form, so that by clicking on it, the whole Excel will be minimized along with the active user form, and when I click on the minimized Excel icon in the taskbar, both Excel and the user...

Greetings and good time dear teachers: In an Excel file that has entered a series of specifications and also has a row, if we want to enter a specific and fixed cell, when we enter the row number, that desired row will be deleted and also pasted in another sheet, of course with VBA. What...

Hi, dear professors and friends, I have a question, please help me🙏🙏 I create a file in the folder using the following code Sub CreateTxtFile() directory = "D:\Data\" Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.CreateTextFile(directory & "F100.txt ") End Sub I...

Hi, I have VBA code that I got from online, it sends email out to several recipients with each their own text if necessary. Now i would like to add an attachment unique to each recipient. In my code i see that it already has an attachment listed, but it does not work, when i sent out a test...

I want to save activated worksheet i.e.template at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet(template) again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75...

Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...

I'd like to generate a function for a specific cell, where the amount increases or decreases, depending on what the user types into a specific cell - connected to two different buttons. Once clicked a button, the cellvalue needs to add/subtract from the original value, mounted in a separate...