Read/Write to Excel from VBA UserForm

[shennricks]

I am looking to create a vba macro that has a userform that will write all of the populated fields to a new row in excel but can also read a row based on a unique identifier. I'm wondering if I should create a class that will take all of the fields and create an instance at the click of a button or if that is necessary. The idea is this will be a single source of data which will eventually drive other macros in the future. I'm just trying to wrap my head around a structure as I'm still learning and don't want to create a mess for myself later in the development.

 

[dmt32]

Hi
welcome to forum.

If you are new to userforms here is a good place to start: How to Create Excel UserForm for Data Entry
An informative tutorial that should get you started & you can download sample workbook for free.

Dave