cellsemptyrow

  1. B

    Setting up Previous and next Buttons for search results

    Hello everyone, I have my userform almost done. I am able to do my searches, a it sorts the data properly. It will show first match in my form, but have added Prev and Next Buttons to look through similar matches. I am not sure how to get it to work with the search results. Here is a screen shot...
  2. B

    Saving updated data record on current line vs saving new record

    Hello, Current userform has a save button, wich adds data to sheet 1, Added Search Button to find saved data for editing. If I use save button for Updated information it adds the information like new data at the bottom while old version still in the list. I added update button to use only when...
  3. B

    VBA Search for any of three items, return whole row or rows of matching data.

    <colgroup><col span="2"><col><col><col><col span="2"><col><col><col><col><col><col><col><col></colgroup><tbody> I recently added a search button to my userform, But it does not seem to search. I am trying to use existing Text Boxs for searching by either Customer...
  4. B

    Clearing Userform Data, After populating "dataSheet" or Getting "Clear Button" to Work on UserForm

    My First time posting, Newbie At VBA. I have been trying to get Userform to clear automatically after hitting OK Button, but also want it to work when Hitting the Clear Button. I have tried Numerous ways to get this to work But, they didn't so I "Commentted them out" so not to interfere with...
  5. Weeble

    VBA Worksheet Change, loops and crashes Excel. How to work around?

    So I am trying to paste information into a sheet. When information is pasted i want this code to run. Private Sub Worksheet_Change(ByVal Target As Range)Dim emptyRow As Long 'Sätt fliken lager som aktiv Worksheets("Uppföljning").Activate 'Determine emptyRow emptyRow =...
  6. A

    Excel VBA & Userform: How to insert data on a specific row which value is based on the value of a textbox in userform

    Dear All, i need a problem with an excel file where I use an userform with a date in a textbox which is always the date of today. I would like to insert data from the userform only in the row which value in column C (a date) is correspondant to the date of the textbox in the Userform. I want...
  7. D

    VBA function IF

    Hi all, I try to make appear on the cell Cells(emptyRow, 11) the value ''HIGH'', ''MEDIUM'' or ''LOW'' in function of the value of the cell Cells(emptyRow, 10).value I mean if the value of that cell is more than 6 the value of Cells(emptyRow, 11) is ''HIGH'', if its value is less than 1...
  8. P

    Add multiple lines from ListBox in columns

    Hey guys, I have a problem I can't really seem to get working. As of now I have a userform where you can input in to textboxes, listbox and adds it to another sheet. That works fine. Right now i want to give the user "add item" listboxes where they can add multiple items in the left listbox...
  9. P

    Writing data from UserForm to empty row and different colums

    Hello, I am busy with make a code that we can use de UserForm, fill in the Form and the button OK will copy the information into the first empty row and in differen colums. This is the code I Use: Private Sub OK_Click() Dim emptyRow As Long 'Make Sheet1 active Blad5.Activate...
  10. S

    Calculations for ages

    Hey Guys, I have kinda complicated UserForm and tried to do some tricks with one extra button, but as soon as I have created it and try to press it takes me ages it keeps saying "Calculating" for like one minute before transfering any data to the sheets. Maybe you guys have any idea which of...
  11. S

    VBA Date Format Switching

    I have the following code: Private Sub CommandButton1_Click() With DOBTextBox .Value = dDate .NumberFormat = "dd/mm/yyyy" End With End Sub Private Sub DOBTextBox_Exit(ByVal Cancel As MSForms.ReturnBoolean) With Me.DOBTextBox If Len(.Text) > 0 Then...
  12. A

    Userform Loading Time

    Hi there, I have created a userform but when adding data to my spreadsheet it is very slow and takes around 30 seconds to input data from the userform to the spreadsheet. Here is my code for my add button, is there anything wrong with my code that is causing it to be slow? Any help would be...
  13. R

    Userform - Input data ABOVE Total Row

    Hello again! I have a userform that adds data to the first empty row within a certain range. What this does now, if there is a Total Row in my table, is adds the data under the total row. This means it is not being added to my table. Is there a way to adjust my current code to add the data to...
  14. R

    User Form - Issue (VBA)

    Hello! So in response to a previous question, I went ahead and made a User Form. However, the skills that I am lacking make this one thing quite difficult. I created the form and used the Date to display an error if the text box associated with the Date was not entered in a specific format...
  15. D

    Getting userform to look at column b as empty

    Trying to find out what I need to change to get a userform to look at column B for empty row and not column A I want to number column A this is the code I have now it finds the empty row in A [code] rivate Sub CommandButton1_Click() Dim emptyRow As Long 'Make Main Sheet Active Sheet1.Activate...
  16. A

    Run-time error 424: Object Required

    Hello, I am an excel beginner trying to make a UserForm for data entry. I made the UserForm and had it working, then accidentally saved the file as the wrong format and had to make a brand new one. I was able to copy the code and add it into my new VBA with all the same box names, but now when...
  17. D

    Userform Textbox faint text

    Hi Peeps, I hope someone can help me with my query. I have tried searching on the net but to no avail. What I am trying to do is have "Please type your name here" displayed in the textbox, but when you start typing in something, that disappears. I also need it do display in another box which...
  18. P

    USERFORM fill out and transer data to new sheet

    Hi really helping you can help me with the code below please, i have a userform which i can fill out, when i click the ok button i want the information entered to be transferred into sheet6 in columns a - d then every time new info is added to goto a new lane, but i keep getting erros pop up...
  19. Weeble

    VBA Textbox CDbl not working with Dots. 2.5 = 25

    Dim emptyRow As Long Worksheets("Tider").Activate 'Determine emptyRow emptyRow = WorksheetFunction.CountA(Range("A:A")) + 1 'Transfer information Cells(emptyRow, 1).Value = CDbl(DateText.Value) Cells(emptyRow, 6).Value = CDbl(UserText.Value) Cells(emptyRow, 7).Value = CDbl(P10Text.Value)...
  20. D

    Insert data from user form to first empty cells within a row

    Hey there, I'm currently stuck on how to do this. Below is an example of what the worksheet looks like. I have provided what userform1 does and performs the way i want it to. First row that contains data begins at "4". Rows 1 through 3 have merged cells, not sure if thought would effect the...

Some videos you may like

This Week's Hot Topics

Top