Search results for query: *

Hi everyone Please could someone help me with this. I have two textboxes txthr and txtmin and want to join them when prcd btoon is pressed. I want to join them as time in format hh:mm. I think I am supposed to get the to join as a string but dont know how. They will then transfer to an...

I have a user form with 112 text boxes. Is there an easy way to make the whole form numbers only without programming every text box..I can do numbers only by text box Thanks

I am struggling to find a code to calculate the financial year depending on the DATE input by user in DATE field. Basically if a user selects date 29/1/2010 from the DATE column in the year column I want it to auto return 2009/10 in the Year Column. If the date is 29/1/2011 it needs to return...

I am looking for coding that will enable extration of data from 5 different workbooks to a central data store. The Workbooks are named South, West, East, North West, Scotland. The other is called Data Store. All Sheets are called data I need the macro to run from the Data Store Workbook and...

Evening I am trying to get a text box to display a value (date) based on any cell that has been double clicked on from an excel sheet. The user form loads up but I cannot get the txtbox to display the date from the activecell. Thanks

I wish to add more text to an existing cell, that already has some info in. I want to create a item tracking history according to ref number. I can find by ref, offset to column etc but then I need the newly input txt to Set a new line in the cell (just like Alt and Enter if manually updating...

Can anyone tell me how I can get VBA to automatically return a value in a textbox depending on 5 choices in a combo box. Thanks

I have ssheet that column A is a list of headings, column B is empty and Column C onwards have data that relate to the headings. I need to copy and Paste Column C into Column B and print. Then copy Column D into B, Print and so on so forth until the loop reaches an empty column. Can this be...

Hi all I need a way of validating a string of between 9 and 11 characters. Unfortunately the string can be totally random with numbers or text appearing in any of the digits. eg 87878E78H or H2454565456. How can i ensure that this is possible in VB user form text box? Many many thanks Nikk

Is there any standard VBA that will auto scan image when comman button is selected. Thanks

How do I get a Mail Merge VBA to work in Sharepoint. I have an excel list and the Word document loads up but will not find the excel list, even though file path etc points to it. As soon as I take the process out of sharepoint and back into a normal IT platform it works perfectly, loading up...

Can anyone point me in a new direction. I have a macro that looks at tomorrows date and extracts lines of data using tomorrows date, where that value os found in a particular column. Now this, although clunky macro does its job but I need a version in which the date can vary by user input...

Is it possible to add hyperlinks in a user form to link to different word documents for mail merging. I can get the docs to open through option buttons but non of the mail merge works correctly so need a more standard approach. Many thanks

I am trying to produce a macro that will match a ref number (in specific cell on the worksheetA) to another separate (workbook (Data) and specific sheet (main)). when the match is found it will transfer data from specific cells on WorksheetA to corresponding cells in the other...

Hi all I am trying to extract lines of data based on a date column within excel. Basically the date column lists interview dates. Each day a user has to extract the following days data and insert into a blank spreadsheet. I would like this to be done via a macro that opens and requests the...

I need a macro that will transfer lines of data information form one sheet (in a workbook = Workbook1) to another sheet (in another workbook- Workbook2). The headings in each workbook are mirror images. I could do it easily enough if I was guaranteed the same number of lines every day in...

Hi there I am using a standard excel form that will import pictures from another excel file. I can get a macro to transfer the image but cannot get a macro to delete the images from a clear data coding. The problem is that every new image obviously creates the next picture number and I do not...

I am writing a Excel database and one of the functions will include the automated searching of appts that the date = tomorrows date, which will obviously be diff each day The column that the date of appt is in date format. Can any one advise me on the VBA for this function. Thanks