Search results

Hi All, I am hoping you can help, I am currently working on a project which requires the operator to request (via email) a number of documents from various departments. I have a standard list of 40 documents which may need to be requested. However the documents are relate to different...

Hi Hui, Thanks for the explanation, I kind of understand I think!! Assuming I have understood correctly and whilst your solution works perfectly, would it be beter if I used a standard named range say A1:A5000 as oppose to a dynamic one Just one further question, If I were to use indivual...

Hi Hui, Thanks for the reply, that code has done the trick. I really appreciate you guys tkaing the time to help the less proficent amongst us. In an effort to incrase my understanding and assuming its an easy task would you be able to give me a quick run through of what the changes you...

Hi All, Firstly this is a contiuation of a project for which I have already recieved som valuable inout from som of the guys on here so Thanks for that. However as this is a slightly different issue from any previosu threads I have started I though it might be better to start a new one to...

Hi SirJB7, Apologies for the delay, and thanks for you help so far. The sheet was probably a little confusing as it is work in progress. I have uploaded a modified version here: https://skydrive.live.com/redir?resid=F5966AED44B736E9!159&authkey=!AIBmocaG2dwTpFE As you will see on Sheet...

Sirjb7, There is a link to a copy of the file further up this thread. Any help you can offer would berate fully received What I think is happening is that once the code replaces the cell it retires the change event before it can run the second line.

Hi Deb, Apologies for resubmitting an old thread. I just noticed that the code you generously supplied below, only works for textbox 1, what i mean is if I add another line Sub CommandButton1_Click() Sheets("Data").Cells(Sheets("Sheet3").ComboBox1.ListIndex + 2, 2) =...

Hi Deb, Yet again you have helped me out of a Hole!! Thank you very much!

Hi All, I am back again! I have searched various forums for the answer and whilst the date format issue using textboxes is abundant I cannot seem to find a solution to my specific problem. OK so, I have a workbook with 3 worksheets. Worksheet 1 contains various textboxes into which the...

Hi Guys, Sorry to resurrect an old thread! Debs code worked perfectley for textboxes so attmepted to amend it for specific cells (see below) Sheets("Data").Cells(Sheets("Sheet3").ComboBox1.ListIndex + 2, 6) = Sheets("Sheet3").Range("D21").Value However whilst the macro doesnt error it...

Hi Deb, Thank you SOOOO Much!!!this has been sending me insane for days! I really appreciate yours and all the rest of the Guys help on this forum it has become an invaluable source of help and information So Once again thank you very much indeed & have a great day!! Craig

Hi, Thanks for all your responses, I guess maybe I have confused the matter slightly. What I am attempting to do is on sheet 3 I have a combobox which populates the textboxes based on the selection. The data that is used to populate the textboxes is stored on the worksheet named Data...

Hi All, I have recieved som invaluable help from this forum recently so thanks to everyone wha has taken the time to reply. Although I am slowly getting to gips with the basics I have yet again come up against an issue which has me slightly stumped. I am using a worksheet as a data entry...

Hi NARAYANK991, Thanks for your reply. You are correc the procedure will alwys be the same, the cells to be copied will be fixed and I am trying to get them to paste into the next unused row as per your comment. As I mentioned I can work out how to do this is the cells to be copied were A1...

Hi All, I pretty new to the world of VBA so please forgive my possible simplistic questions. Ok we basically what I want to do is using a command button copy and paste only certain cells from worksheet 1 to the next empty row on worksheet 2. I have worked out how to do this for complete...