Does anyone know how I could speed up the following:
Dim wks1 As Worksheet
Dim wks2 As Worksheet
Dim iRow As Long

*Please help with this*, I am using 2 button presses to swap ranges
( I have 30 ranges and 30 buttons)
and I am using Ontime to kill and reset the code if the user doesn't
press the second button within 4 seconds of the first button press.

I have a problem I hope someone can help.
I have a workbook with a VBA project, both of which are password protected.
I want to progmatically save the changes to the workbook.
I can unprotect, change necessary cells, and then reprotect the workbook.

I coded the following Sub to populate a combobox / listbox but it is
generating a Type mismatch error.
Code:
--------------------

Can some please let me know a sample code for simulating the "Form"
found under "Data" in Excel 2003?
Thanks,
Baapi:confused:

I have the following macro. How do I paste the rownumber in cell H32?
Sub test()
myrow = ActiveCell.Row
ActiveSheet.Next.Select

I was searching previous posts before posting my question and didn't find any
that addressed this specific situation.
I have a workbook with 10 sheets. All 10 sheets have code that totals up
column D and puts the sum at the bottom of the sheet. This sum is never

Is there any way I can secure my macros so that no one else can edit o
even see them without a password?
Thank
--

I am new to ADO and am having problems getting a simple example to
work.
When the followig code is executed the 'rs.Orders.Open StrSQL, cn'
command throws 'Object recquired' exception. Neither strSQL or cn are

Can anyone please tell me how to put a checkbox in an Excel Spead Shee
and when it is checked to add a value to a field?
Thanks in advance
--

[B3].Select <==================== Error. Can't Find Project or Library
ActiveCell = Me.ComboBox1.Value
This was working before now it is not.
If a COPY WorkBook was made via a Macro, will the Macro's + Library + Project etc refer to the COPY NOW, or

Heya, I have this excel spreadsheet that store data of some licenses. The
fields consist mainly of the description of the license, expiry date, the
relevant party etc. Due to the fact that this spreadsheet serves as a source
of centralised information, a reminder is required to ...

I have no experience with Userforms and combo boxes, but think they will
assist me in achieving what i am trying to do.
I have formatted a Userform with a combo box, but :
How do i activate it from the worksheet ?

Can anybody please enlighten me why this Excel VBA function* works:
   Function topright(values)
       topright = values.Offset(0, values.Columns.Count - 1)
   End Function

I'm trying to create a personal certificate by executing Selfcert.exe.
I run the program, get the prompt to enter a proper name for the
certificate, but no matter what i enter the program responds:
Can't create a certificate