Search results for query: *

AAArrrgghh What Am I doing wrong. I can write the time back to the main spreadsheet. Then when I relaunch the the userform through CmdStaffData_Click() the StaffData.Show works fine showing the form. The time did pull through but only the last entry I put in. It was expecting it to follow...

irow is defined as irow = ActiveCell.Row and timerow is a global const look up for a column so whatever date line it picks the active row. Will try soon and hopefully put the saga to bed

So are you saying this Private Sub UserForm1_initialize() Dim CombinedTime As String CombinedTime.Value = Range(Timerow & irow).Value txthr.Text = Split(CombinedTime, ":")(0) txtmin.Text = Split(CombinedTime, ":")(1) End Sub

Skip I did try it an nothing happened. I dont think I got the With Cells (1,1) bit right at all. I guess I dont know a whole routine for it

sorry wong code You two are awesome and I have got the first art of Golom coding working and writing to sheet with ease and although text as such the excel sheet is counting nicely. using this. Sorry been working away couple of days Working - updating excel sheet nicely Private Sub...

You two are awesome and I have got the first art of Golom coding working and writing to sheet with ease and although text as such the excel sheet is counting nicely. using this Sorry been working away couple of days Working - updating excel sheet nicely Private Sub CommandButton1_Click() Dim...

Skip I dont understand how to use it? I am a bit clunky with my knowledge and most things I can do are populating cells, if and etc. Sorry Nikk

I have looked up time serialfuntion and I dont understand it and I am not sure it is what I need unless it creates a time input box in the user form. The hours textbox is not restricted to 23 hrs. It could be 245 hours as it represents a total number of hours worked by a team in a day. The...

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

Thanks everyone for the humour and advice. I know what fumei means as the userform with all those txtboxes does indeed look scary but its no different really to a table when you look at it. In reality only 10% of the boxes will be needed by each input so its not all bad. I already knew about...

Hi Skip Thanks for responding I was hoping not to have to program all 112 text boxe, rather program some type of routine that would effectively program all txt boxes to behave and accept numerical when the userform is opened opening. 1. User form opened 2. Routine that programs everything...

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

Thanks for that SkipVought I tried your link and as I work on a server the MSQuery function is not installed and therefore will not work. Is there a VBA way to do it? Cheers

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

This now brings the date into play as expected so many many thanks. The date is reversed ie 2/1/2008 2nd Jan 08 is displayed as 1/2/08. I have experienced this before and do not really know why it occurs?

CELL_MIDATE is a global constant and is set to "B" to represent column B where the date will always be. I tried frmFront_Initialize/Open/Activate to give it some purpose but usually had runobject problems especially with initialise.

Many thanks This is the coding in the Workbook that enables the double click in a cell to load user form: Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean) iSheet = ActiveSheet.Name iColumn = ActiveCell.Column irowno =...

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