.cellslastrow

Good morning, The code in use is supplied below. Currently when i press my Postage Sheet Transfer Button the values are added to my worksheet and the cell in column G is applied the interior RGB colour Red. Please can you advise how i also have text in the same cell, so not only is it then...

hi guys i have userform contains 35 textbox and 18 combobox i would transfer data to sheet i try make the code but it gives me error this line <tbody> </tbody> <tbody> .Cells(Lastrow, i).Value = Me.Controls("TextBox" & "combobox" & i) the error message could not find the specified object...

Afternoon, I have in use the following code which transfers data from my userform to my worksheet. Before i see the message "Customer Postage Sheet Updated" i am looking for a Yes / No Msgbox. Where if No is selected then continue to show the "Customer Postage Sheet Updated" as normal BUT If...

Afternoon, The current working code is supplied below, Basically it allows me to keep certain information about my customers with regards their purchase from me. Currently it works like this. I enter the new customers name in TextBox 2 like example JOHN SMITH "this is his first purchase" I...

Morning, I have a userform which opens when i first come to the worksheet. I then enter all the data in each TextBox & when i press a button the data is then entered into the worksheet. Once the item has been delivered to the customer i then like to enter the date of its delivery. At present i...

Every time I run my macro, it takes about 1 min to execute. How can I fix this? Sub Button1_Click()Dim myRange As Range Set myRange = ThisWorkbook.Worksheets("Data Entry").Range("Data") Dim lastrow As Long Dim whichsheet As String whichsheet = InputBox("In which sheet do you wish to enter...

Hi, I have the code shown below for a userform to worksheet. The problem i have is the following. I mainly use Royal Mail and the tracking format is like so RS1234567GB Sometimes i use Hermes and the tracking is like 123456789123 The hermes transfers to the worksheet fine BUT is shown like...

Another piece of code i am unable to locate. On my userform POSTAGE TRANSFER SHEET i have a Combobox1 which in the properties the Row source is empty. I have looked through the supplied code for the form but dont see any path that relates to the Combobo1 to tell me where the drop down list info...

I have a userform where i enter data then when i press the Click To Transfer button this data is then entered on my worksheet. I would like a code so upon pressing Click To Transfer it should check first that the customers name does not exist. If the name does not exist then let the data be...

Hi, @MAIT supplied a code for data entry from userform to worksheet where it would enter the data into the last row on my sheet. On a new userform that i have just made i would like to use the same code in respect of entering the data from userform to worksheet BUT not in the last row. As you...

So, I am fairly new to VBA and I am having a difficult time with this. I have a template that is to be modified and will be saved and create a new file for each modification (is a template for work shift information). For every different file saved, the main database needs to be updated, so...

Hi, I'm trying to have my sheet look at data in column A, find duplicates, and merge cells in column U,V, and W based on the number of rows with matching data. So if A5:A9 match, then U5:U9 merge, V5:V9 merge, and W5:W9 merge. I can get it to work for one row but I'm missing a step somewhere...

Hello, i'm completely new to VBA I receive the following error 1004 Application-defined or object-defined error. the following code is processing this error. Cells(1, lastcol + 1) = "xxxxxx" Columns(lastcol + 1).NumberFormat = "0%" lastcol = .Cells(1...