Hi does anyone know a good way of programming a undo cotrol on a form?.
TIA
Charles

I'm using a scrollbar to allow a user to scroll through a scrolling chart
(courtesy of Andy Pope).  I also have a code snippet that updates the
"Object.Max" property of the scrollbar when additional rows of data are
added.  

This is the code I used to remove the control, I get runtime error 5 'invalid
procedure call or argument'. Here is the code I used to remove the control:
   application.CommandBars("Worksheet Menu Bar").Controls("cmd").Delete
This is the code I used to Add the control:

Is there a variable available for capturing the user name in the footer of a
document?
Similar to "&[Date]" or "&[Time]" as already exists?

Anyone know of a reliable source of data for the % of users by Office
version?
The only good survey I could find was Martin Green's Office Version
Survey - http://www.fontstuff.com/comment/comment03.htm

I'm writing this from a different PC (the target workbook is only accessible
from certain PCs) so I will gladly post the code as a followup, but I
figured I'd start with a request for some basic information/ideas. I've done
a fair bit of Excel VBA coding, and this is such a simple ...

I have a macro which runs the PasteData macro.
Since the parameters 1 to 5 get populated with new data each time this
macro is run, I want this macro to move to the next empty row and paste
the new record into that row. This process or macro is re-run/

feel like an idiot that i can't get this one right... never-the-less...
B3:B10 have no special format, and could either have text, or be null
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Not Intersect(Target, ActiveSheet.Range("B3:B10")) Is Nothing Then

I use this to get some value in 2 comboboxe:
FIRST:
Private Sub combo_sedatoer_DropButtonClick()
Dim i As Long

Does anyone know of a way to loop through a User-Defined type?
Here is what I am looking to do.  Say I have this UDT...
   Public Type BigType
       a1 as String

I am using outlook express and have to press send for the email to go.The msg
is correct. can anyone tell how to get around this.
thanks

Hello from Steved
I've a spreadsheet that has 2 columns of Data
If I type in 003,3.20 that's fine but sometimes there may be more with the
same data, how can the below macro be modified to find the next and so on.

I am currently working on a project in Word VBA.  The userform that I have
developed has a number of combo boxes which are populated from an Existing
Excel Workbook.  What I would like to have happen is when a user enters
information into the combo box, the program searches the ...

I'm trying to create a multiple choice test in Excel (2002) format and I
would like to create an icon of a box, that when clicked on, will insert a
check in the box (a macro would be running in the background that would keep
a running tally of correct scores).  How can I do this?

After deleting a query, and deleting its name from the name list, I
can't recreate a query with the same name without closing the workbook.
Here is a sample subroutine that illustrates the problem:
Option Explicit