I have developed a forms through excel VBA, and the forms contain text box,
option button, commandbutton etc....
I need a macro code to create shortcut key to my commandbutton and
optionalbutton, for example : if i have a commandbutton called as Cancel, the

I cannot enter fractions in a TextBox and have them recognised as numbers.
If IsNumeric(UserForm1.TextBox2.Value) = False Then 'Quantity
MsgBox "Choose NUMERIC quantity. Transaction cancelled!", , "Company Name"
End If

I'm making a function that works with the Range.Comment object.
There's Comment.Text, but if there's nothing in it, it just errors
out.
How to check if .Text exists or not before attempting to read from it?

i have this basic macro provide by forum member that can do a lot of work.
but due to more demands, i like that this macro can be separately operated
made for each sheets in one workbook.
In a way that when i place in A1 the text for Target Directory, the macro

I am preparing a user form.  I am facing the following two problems:
i) I want the user form to load when workbook is opened.  Under ThisWorkbook
< workbook < Open, I have written   frmxyz.show.  Still the form is not
showing.  I am getting Error 424:  Object required.  I tried to ...

hi all.. i need to make the macro to format all the cells of my workbook like
this...
if cell is equal to 2 then
paint it red

I need help in switching back & forth from sheet to sheet and using
VlookUp
& Match to retrieve values at the intersect of current Row & Column.
.

Good afternoon --
I've designed a workbook to have checkboxes on two worksheets.  Then, I
wrote a macro to open the workbook in two tiled windows (so that reference
info stays visible in one window when the other scrolls as the user adds more

I have a working set of classes and routines in Excel 2003 written in VBA.  
They return the correct answers.  The various functions do goal seeking and
reading and changing various cells in my spreadsheet.
I created an activex dll in VB6 and moved the code over.  I included the

I have a client that creates Excel reports by using links to a large master
spreadsheet.  The reports are constantly changing and needless to say the
process of checking to be sure that the links are referencing the right cells
in the master sheet is a painful task.

I have a single table in my xlsx file.
I would like to create a [static] html (.htm) file containing this
table.
Keep in mind that I don't want to save the workbook or worksheet as

I need to do something with a comma delimited block of text.
....like
text ,  text, text, etc
Can someone help me write a loop to loop  through each block of text between

I have a userform (ufRepInfo) in which there is 28 text/combo/check boxes and
1 command button (cbFind).  What I have done is made it so that when I put a
value in the textbox (tbZipCode) and hit the Find button (cbFind) it will
return the rep information stored on Sheet1 into ...

I have a worksheet that has multiple queries.  Rows 6-some number (fluctuates
each week) contain the data from columns A-G.
There is another query that starts ~5 rows below the first one and goes for
another 10 or 20 rows from columns A-G again.

I have a file that creates a daily build schedule..Is there any way I can
create a macro function that will automatically vlookup the comments /details
from the most recent file??? Or be able to select the file where to vlookup
from???