Whets the best way to have a form show on opening of a spreadsheet?

I have a userform that stores data (1 row record with 20 columns) to a
worksheet.Is there a way to grab the data back in (other or the
same)userform, ambent(correct) data and store them back in the same row
in the worksheet?

Selection.subtotal GroupBy:=lngcontrolcol1, Function:=xlSum,
TotalList:=Array(13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25),
Replace:=True, PageBreaks:=False, _
       SummaryBelowData:=True

I'm trying to copy every third cell of column c starting at C16, and paste
into column C of the next blank row of a separate workbook. This code below
kind of works but it errors where I've defined the 'pasterange' in the other
workbook (I think this is incorrect but you know ...

On each page printed I want to sum a column on that page and print that total
on the bottom of that page, probably in the footer (ie a total amount for a
data entry balancing process performed elsewhere). Each page has its own
total it's not a running total. I've tried variations ...

The following code is designed to copy 2 charts from one sheet and pastes
them as a picture onto another sheet.
How do I assign the pasted picture to a variable so that I can manipulate it
(i.e. change the location, width, etc)

Please could any one prepare a macro for me with following details:
I have data base of about 100 questions divided into various groups. I want
a macro where in every time I get a set of randomly selected 20 questions
representing questions from all the groups.

my code ActiveSheet.UsedRange.Rows.Count gives 5002, but i am only
using 1 (cannot set to one as in future this will be dynamic...)
any ideas?

is there a way to select all the autoshapes on a sheet in vba? At the
minute I'm looping an iterator and concatenating onto the word
"autoshape", deleting "autoshape 1", "autoshape 2", "autoshape 3"...
this is horribly inefficient and besides, stops working when a shape

I wonder if anyone could help me with my problem. I have a list of data, and
I want to sort out data by name, for example by project. If a user selects a
prosject only the informations that contains this prosject name will be
showed. Each prosject name have different sub groups, ...

I have reports that will printout to 1 or more pages.
I use the following code to determine how many pages there will be
ActiveSheet.VPageBreaks.Count
Is there a way of alternating the position of the header.

I have a list of 30 names. A macro should input the first name into cell A1,
print the spreadsheet, input the second name into A1, print etc.
The list can be either in a spreadsheet or in the VBA code.
I used to copy-paste the following code 30 times and had to replace {name}

Within cells, I have TEXT strings, such as:
      A
1    abcde
2     fhjuy

i have the data in this format
name     Jan       Feb       Wed
alan        5         10         15
ben         6          0          3

This may be far fetched....
I'm curious if it is possible to link Google Maps with an Excel Userform.  
The user would enter the starting zip code, then the ending zip code.  The
userform would return the calculated distance [in miles].