addme.offset0

When deleting an entry from my DB using a vba userform I received an error: "An error has occurred the error number 91 object variable or with block variable not set" With my limited knowledge of vba I'm struggling to understand what the issue is, please could somebody advise? My data writes...

Trying to create a parking lot database that is editable through a multipage user form. Since 1 parking spot can have up to 3 different vehicles parked in it, I'm trying to figure out how to be able to search multiple columns at once. This is the original layout. i.e. I need to be able to...

Hi, Fairly new to Coding. I have a code that will get an input from the user, save it as a public variable: "ProjectName". create a directory using "ProjectName". copy a template worksheet and name it using "ProjectName". next The code will open a new form to get more data from the user. now I...

All: I have a listbox that is populated by a dynamic range from another sheet. The listbox has (1) command button. Once that command button is selected, it "grabs" the selected lines of record and adds them to a worksheet so those records can be assigned. Below is my code that I am working...

Hi All, Greetings! I've been working on a user form to track my inventory. I am using the following code below to add new data but it does not automatically increment the ID. My data range is from Sheet 7 - B9:J2000 and my ID column header is in B8. I'll need help to correct this code to have...

Hi, can some one help me to add search option in user form(search as you type) here is the code Private Sub cmdadd_Click() Dim addme As Range Dim x As Integer Set addme = Sheet1.Cells(Rows.Count, 3).End(xlUp).Offset(1, 0) For x = 0 To Me.lstSelector.ListCount - 1 If...