I changed the code as follows...
If CheckBox1.Value = True Then
CheckBox1.Value = False
Sheet7.Visible = xlSheetVisible
Dim i As Integer
For i = 1 To TextBox29.Value
Sheet7.PrintOut
Next
End If
--
--
Some import
Hi
This part of the code i use currently. all sheets are veryhidden so i first
unhide and then print... there are some code before it...
If CheckBox1.Value = True Then
CheckBox1.Value = False
Sheet7.Visible = xlSheetVisible
Sheet7.PrintOut
End If
how will i use it with your code?
Thank
Hi
I have 10 checkboxes on a form. Each check box is linked to a page.
When a user click commandbutton1 they print what eversheet is
connected to the checkbox. For example:
have a tick mark in checkbox 1, 3, 7 and 10. the commandbutton
firstly go and print the sheet assosiated with checkbox1 t
hi
Does not need it to be in one cell. But would there be a easy way to
get them all on the userform?
On Sep 3, 4:50 am, Bruno Bruno wrote:
> Just for curiosity, do you really want to put all the information in the
> same cell?
> For example, instead of putting in the "this month" cell [*A Swan
Hi
This posting relate to a earlier one regarding birthdays on a excel
sheet.
in column a i got the /mm/dd
column b i got the person name and last name
column c i got the age of the person
in d1 i need every one that has birthday today with theiry respective
age next to the name. since the
hi
Yes that does exactly what i need to be done... Thank you!!! but
now
I need the all people that have birthday to day or tomorow or day
after to apear on a userform. (take note that there maybe more than
one sharing a birthday)
i use label34 (today) and label35 (tomorow) and label36 (day a
