How to enter data from userform if table is in the middle of the spreadsheet

pparnaso

New Member
Joined
Jan 18, 2019
Messages
1
Hello guys,

I am creating a template to log activities and account history and I am unable to add data if my table would start in a cell not at the beginning of the sheet (ex. first column is at C33).

The template I am creating will be the same template used for each new sheet generated named after the customers. So the code must work on every sheet generated even if the sheet name changed.

Here are the information I wanted to see on my table:
Activity (Combobox)
Notes
Date
Outstanding Balance
Overdue
Payment Promise

I am new with VBA and has no formal education for it. Just watching videos in Youtube but can't seem to find something that works for my situation. Badly need your help guys!

Thank you.
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Watch MrExcel Video

Forum statistics

Threads
1,118,886
Messages
5,574,836
Members
412,620
Latest member
sharma7s
Top