i have an excel 2002 form in which textbox10 requires an answer of Yes or No.
if vbNo i would like to jump to textbox20 which i have set the focus for.
what i want to do is TAB only once and be in textbox20 is this possible, if possible can anyone suggest a method of doing this using VBA
i have a list box with 4 colums of which the first colum sets up the stage for a macro to run. in order to get the macro to run i have to click on a command button.
can any one suggest a method whereby i double click within the list box to run the macro
i have 5 different procedures each procedure runs as a stand alone but all have one thing in common, they use the same 10 private modules.
how or where can i place the private modules so that i can call them from the different procedures. is it possible and if so how can i achieve this
having brought our server to a grinding halt by sending out a series of emails to my customers, our IT dept suggest i send out a noumber of emails per hour.
the emails usually have an attachment and normally approx 300 kb
if you have ever tried to send out an email at 30 minutes intervals...
i am trying to send the same email to my contacts if i send them all at once the main server rolls over.
can any onr suggest a way to send out every hour the same email but to different contacts.
this i must state is not for sending out SPAM which i detest
i know its easy to paste a formula into a colum as(D1:D1000).
has any one any ideas on how, to only paste the formula in colum "d" only to the last row of colum "C"
any one any ideas on how to split a colum of upto 10,000 rows into two halves so that the bottom halve can be selected and moved to another position or work sheet
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.