Search results for query: *

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

thank you for your response , i have now found what i was looking for

has any one found a place to store the abundance of bits and pieces one finds. a library using excel would be of help especialy for VBA snippits

thank you works a treat

Ta i will try that tommorow

either i have missunderstood your reply, or!! i am using a listbox in excel2002 sheet2 holds all the data for the listbox

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

try SHEET4! it's the end bit which tells the formulae where to go !!!!!!!!!!!!!!!!!!!!!!!!!!!

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...

have a look at this site great for sending single page or multiple pages to different addresses http://www.rondebruin.nl/index.html

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

thank you for a quick response, whilst i am able to say that the solution works exceptionally well in one instance. in a second instance using the same module but to take into account that the sheet in this case only had 3 columns, only a third of the file was moved to the final position in cell...

hi just to let you know that this works ok for me but with reservations. i have two sheets both with the same format either 3 columns or 4 columns wide. The 4 column wide works a treat but the 3 column on is perculiar in that some times it only takes approx the bottom 1/3rd of the column and...

thank you for your quick response,i think i have misled you If in colum "D" i wanted to have the formula say "=sum(c1+8)" to be coppied and pasted into colum "D" and only to be pasted to say row 1000, which is the same row as colum "C" finishes at.

have a look at chip pearsons site http://www.cpearson.com/ and look for his programme on lists!! very good and could help you

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"

thank you for your input(ETID & SkipVought) i have tweaked it and it works exactly as i want it to Option Explicit Sub SPLIT_COPY_PASTE() Dim LAST_ROW As Integer LAST_ROW = Sheets("sheet1").UsedRange.Rows.Count ' (1) LAST_ROW / 2 gives the centre position of the column ' (2)...

i feel that i have missled you in one respect that (and this is my fault) the range consists of 3 x colum's and up to 10,000 rows long

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