.cellslrow

I have a spreadsheet with a userform used to add entries to a mapping table of items. There are four fields which need to be input and once done the entries are appended to the bottom of a table. What I need to do is get the code that inputs the data to look for a duplicate entry for the first...

I'm putting together a spreadsheet to compare trades from an external clearer to my company's internal processes. For this there is a requirement to keep a mapping table updated so if we trade something new we can update our data and ensure everything matches. Now, here's my code for the...

Hi all. The code bellow checks customers sheet for a customers name then if it already exists, then it returns a message and then customer textbox is cleared and set focus to. however, the focus is not working but instead it's focused on the next textbox. Private Sub tbnbna_AfterUpdate()If...

Hi All, after receiving a cracking answer to an issue I raised yesterday on the Forum, I now seem to have an issue with around Date Formats For my user form I have 3 different text boxes for Date entry, so I have set up code for each one to format the Date into UK format This seems to allow...

I have created a couple of user forms in vba, they work fine until I click anywhere in the user form that is NOT a field, when I click outside of a field, I get the following error: Compile error, Sub or Function not defined. Again, this only happens when I click inside the userform, but not in...

This is my first post so please be gentle with me. :cool: I am currently using Excel for Office 365. I have a user form for data entry to either of two sheets, the sheet is selected in ComboBox5. Sub EditAdd finds last row of the existing data (using column C as the reference) and puts the...

I'm really new to VBA. Below is the code that downloaded with the excel file. What I'm looking to add to the user form is to be able to display an image of the corresponding part that has been filtered from column "D" into column "O" LookUpLists sheet from the Part ID combo box and display it...

I am trying to add and remove items from an activex listbox with multiple columns. Whis this code I only remove parts of the items in the listbox and in the rowsource, I think you could say that it doesn't remove all columns. Code to remove items: Private Sub CommandButton2_Click() Dim sFind...

Hi Guys,, Need your help.. How to make this formula works with .csv file/s. Thank you :) Dim fso As Object Dim fld As Object Dim strSearch As String Dim strPath As String Dim strFile As String Dim wOut As Worksheet Dim wbk As Workbook Dim wks As Worksheet Dim...

Hi All: When the criteria is met, I want vba to copy entirerow from external workbook/s to this workbook starting from a selected cell. Example at cell (C2) instead of (A2) as per current formula. :) Dim fso As Object Dim fld As Object Dim strSearch As String Dim strPath As...

Hello! I need to set a dynamic range for formatting a report. The number of rows and columns will change regularly, and not all of the rows will have data. I put this together based on research in this forum, but I'm getting a "Compile error: invalid or unqualified reference" on ".Cells"...

Hello experts, I have a simple form (pic att.) where it should show the picture of the person selected in the Drop box, any help is really appreciate it. I am also adding the code that I am using. The pics are saved in a file, but I am planning to save them later in SharePoint site. VBA...

Hi all, I am currently using the following code transfer data from text boxes on a userform to a spreadsheet in the same workbook. What I need to happen is for users to all have their own individual copies of the userform which they would have on their desktops, but for the data to be...

I have the below code which gets input from the user and inserts to a sheet called Dashboard. The bolded line of code perfectly starts from the first empty row and then work its way down for each entry. Is there any possibility of doing the below? Combobox1 will have 3 selection for the user...

I have created a userform with a TextBox and ComboBox controls. The user key-in Date in TextBox and selects data from each of the ComboBox. Which are then saved to the worksheet named "Dashboard". Below piece of code does that perfectly. Private Sub Add() Dim lRow As Long Dim ws As Worksheet...

Hi all. I have developed a basic userform and it works perfectly adding new data to the bottom. The thing is, I don't want it to add new rows. I would like it to cycle through all rows that are filtered (separate macro filters before form opens), and then pre-populate all the form fields with...

Hi All, I have created a Userform for a task project I am working on for my job. I am not a programmer and have limited knowledge of excel. In essence, I have created a form that will be used by about 15-20 people for entering tasks they have completed. The details are then inserted into a...

I am using a macro from a co-worker that is no longer with the company. Its a macro I attach to our main frame emulator. When I start it with a spreadsheet open it takes a code number from cell B2 on the spreadsheet, pastes it in the emulator, hits enter and then screen scrapes 6 pieces of...

Hi, I'm looking for a way to convert the textbox value so that if I put for example 5 in the textbox it will appear as 5% in the cell. I wrote the code in this way: Private Sub UserForm_Initialize() TextBox6.Value = Format(Me.TextBox6.Value / 100, "Percent") TextBox8.Value =...

I've created this code to format my textbox, which is working well Private Sub UserForm_Initialize() TextBox1.Value = Format(Date, "mm/dd/yyyy") TextBox6.Value = Format(Val(TextBox6.Value), "#%") TextBox8.Value = Format(Val(TextBox8.Value), "#%") Ens Sub However I noticed that...