Recent content by 2ks

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