Excel Help (macro, cell size, vba)

[lwilson80]

Hello,

I'm new to VBA and currently just playing around with features. However, I have a few general questions in regards to Excel/VBA. Any help would be greatly appreciated, THANKS!!

1. How do I keep the cells one set size, despite how much data I enter into the cell? For example, I have no problem if the width expands due to text input but how can I keep the length on set size?

2. Can someone provide a script for a userform? In addition, to the Userform script, how can I have the details below correlate with the userform? Here are the details I would need in the form:

• I would like the labeled fields on the userform to go to specifically labeled columns. Furthermore, I need for every time new data is input into the form, it automatically goes to the next blank matching labeled columns/cells. Not to mention, can there a be a feature to update previous information input into the userform (i.e. for like customer contact information).

3. Can someone provide a daily pop-up notification script, that will pop-up at a certain time during the day?

4. Lastly, is there a way to incorporate a webpages into a spreadsheet and set the cell sizes to still reflect all the data of that page? Currently, I imported a webpage, however, the cells expanded too much and I constantly have to scroll over to read the data.

THANK YOU!!!