onewrow.range.cells1

I am creating a userform to record incoming business opportunities across multiple work-streams and need help with the Unique ID feature of the coding (appreciate this is a common question and I have looked, and looked again and Googled - but I couldn't find anything for my situation) as I'm...

Hello, I would like to find a solution to this issue I am having. I have a button that runs this code: Sub CopyValues() Dim ws As Worksheet Set ws = Worksheets("report") Dim oNewRow As ListRow Set oNewRow =...

Hi, I have a form control button on Sheet 9 that opens up a userform. I want the data entered into the userform to be entered into a table (table3) on sheet 8 of a workbook. When the control button is on sheet 8 the code works perfect, but when the button is on page 9 it does not. The code I...

Hey everyone, sorry, my VBA is pretty limited. I am trying to create a new update form by reverse engineering a working form. I am getting error '1004' "Select method of Range class failed". The error is from "rng.Select" but I dont see anything wrong with the code where the range is defined...

Hello Everyone, I have a form that I am trying to create to insert a new table row and populate some of the row values. My VBA is not great and what I have was built from several different sources. It is working, just not quite like I expect to and I dont understand where the error is coming...

Hi All I have a userform (Code below) that writes new data to a new row in an Excel Table. What I also want to build is the ability to search for a row in the database (Column A in the table is a primary key) and then allow a user to overwrite the data as per the userform. Not too sure how to...

Hi Can anybody put me right on a 'Compile error: Sub or Function not defined' please. Have had my first try at a userform and have copied this from the web. The userform has many labels and text boxes and a few combo boxes. Basically i'm looking for the form to populate a table called...

I am having issues with 3 codes. Hope its okay to post all 3 together they are all part of a userform. I created a table then a userform to enter the data., search the data, and delete data. I am needing this code to have where it will check for duplicates and a message pops up if there is a...

I have created a userform that inputs data into a table, the code below works for adding the data. the trouble i am having is getting the search command button to work to look up Fnametxt in Col B of table and pull data back to userform based on name type into search box. then to beable to...

Hi there, I'm a complete VBA newbie but have managed to muddle through so far with the project I'm working on. I've basically created two forms, the first form is to add details to an excel sheet using a combination of text boxes, drop down boxes and check boxes. This form is working exactly...