An event is something that happens. Modern languages allow you to monitor
and act upon events.
For instance, opening a workbook is an event. VBA allows code to be written
that is triggered by that event, and allows the developer to take action
based upon that workbook opening.
Other such events are a worksheet being activated, a cell being selected, a
cell being changed.
In your book, being
VB, it probably won't cover Excel events, but should
cover form control events. Forms will have controls, such as checkboxes,
textboxes, command buttons. They would be useless until you were able to
code based upon something happening to them, so many events for the controls
are exposed, such as the click event, change event, etc.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"filo666" wrote in message
...
thaknd tom, I have another question, what is an event?, I found this term
in
tge class chapter of my "VB for Dummies book"ĦĦĦĦĦ
TIA
"Tom Ogilvy" wrote:
Do you have a list of Bill Numbers
to reduce errors, why not use a combobox and let the user select the
Bill
number.
otherwise
Private Sub Userform_Activate()
Textbox1.Text = format(Worksheets("Sheet1") _
.Range("C5") + 1,"0000000000")
End Sub
In the project explorer, select the module and look in the properties
window
(F4 if it isn't visible) Replace ModuleX with the name you want. (Name
is
the only property)
--
Regards,
Tom Ogilvy
"filo666" wrote in message
...
2 questions:
1)
I have a form that ask the user for the bill number (a 10 numbers
number),and the user needs to type all the numbers each time that a
bill
is
done, so I want to use a default value in the textbox1 linked to the
last
value (that is saved in a cell c5) + 1, (in cell c1 appears 0889888881
so
in
the textbox appears 0889888882)
Pd. I know that this can be done automatically, but because there is
some
time that bills are cancelled I need to ask the user for the bill
number.
Pd2. I know that default value is an option on inputbox property, but
I
cant use inputbox because my form has a lot of buttonsĦĦĦĦĦĦ
2)
There is some way to change the module names (instead of module1 say
easyprgms1) and also to lookup for a specific sub (because I have 100
subs
and each time I need to modify something I need to check in each of
the 15
modules that I have)
Tanks for your Help