Posts by stevehorton09

Hi People,

I am currently working with a stopwatch function (using a form)

At present the function i have created has two command buttons, one start and one stop which gives the date and time from clicking each button (one in a1 the other b1)

What i want it to do is not overwrite the information each time but just go to the next line (a2 and b2 etc etc), how do i do that?

Cheers

Steve

Code currently is

Private Sub CommandButton1_Click()
Range("A1").Value = Date
Range("A2").Value = Time
End Sub

Private Sub CommandButton2_Click()
Range("b1").Value = Date
Range("b2").Value = Time
End Sub

Hi Derk,

If you have had enough of my stupid questions then let me know and I will give up.

Im trying to do a time sheet, similar to the scoring one but I cant do the same as before.

As you can see from the attachment the user clicks on button it adds 1 to next sheet and then should add to the specifc date in the last sheet but i just cant do it!!!

Can you have a look?

thanks very much for that.

Im just trying to learn the ropes of vb.

Might try a time sheet, if I was to have say an activity page with buttons you would click which by clicking adds one to a second sheet and a third sheet the date, would it be very similar.

I have not been able to create the generic code for the second button. the line i do not understand is

s = ActiveSheet.Buttons(Application.Caller).Caption

or if you can how do you modify the code for the next team???

:o:yes:

hope this helps!!

I have changed the names but should be easy to understand.

They are located along a row B6 to F6 so a week at a time on sheet 2.

I would like each team down the side

So basically click a button(button is team name) which puts 1 in b2 (b1 being a teams name). Then on sheet 2 the date it was scored is added to that team row

Is there anyway of sending this to you???!??!?!

cheers for that,

if i was for example adding up goals scored on a particular day then how would i section them by day.

So i click a button that puts one in B2 and then as it was the 21st May 2004 puts one in another tab (sheet 2) under the 21st May 2004

Next day another goal was scored so its the 22nd, I click the button so B2 =2 and the other tab now shows 1 goal on the 22nd!!!!??????????:o Any takers for this one???:yes:

cheers,

how can i say always make it select b2???!!?

Hi All,

Very simple for you guys, want a macro button where each time you click on it, it adds one to a cell say b2.

Eg click button b2=1, click button b2=2 etc etc

thanks, you have both been a great help

thanks for the reply Dave,

I have looked into this already and my instinct is to have a message box that appears, do you know of a simple code to do this,

I have the attachment if that helps;;)

Hi There,

I have setup a spreadsheet where if a set of numbers is duplicated in a cell, the next cell says duplicate (using an IF Statement).

What I want is that when the set of number is duplicated, the cell next to it still says duplicate and then a message box appear saying Warining Duplicate!

I cant work out how to do to message box part.

Any help would be great!!

Thanks steve

:biggrin:

This is my current code,

the active sheet I want to copy then save as 1 then when macro button click it calls it two is called "New Sheet Steve"

How do I input the code?????!?!?!?!?!

' savings Macro
' Macro recorded 17/03/2004 by shorton
'
Application.DisplayAlerts = False
ActiveSheet.copy
ActiveWorkbook.SaveAs Filename:="R:\COMMON\Oracle\Flexfield Update Form\Local accounts\local.xls", FileFormat:=xlNormal, _
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False
ActiveWorkbook.Close
'

End Sub

Thanks so so much, it will make my day if this gets sorted!! Cheers again
:yes:

thanks for that, but how can i save the new sheet each time with a different say number ie. you click the macro and it saves the worksheet as 1 then when you click it again it saves it as 2 etc etc

If anyone can help I will be so so so grateful!!:yes:

very simple guys/gals,

I want to save just a single worksheet of a workbook.

If someone knows also how I can save the worksheet each time with a different say number that would be great.

Thanks in advance

Steve:biggrin:

Cheers for replying,

Iam new to all this!

How would you do that,

Thank you for your time

Steve:tumble:

Hi all,

Is it possible to fill in a worksheet, save it automatically through a macro (which calls it 1). Clear it, fill it in again and then save it but this time as the next number i.e 2 then 3 etc etc!!!!!

Thanks in advance!!:spin:

Hello!

I want to try and set up a system where I can log say a problem with a unique identifier and then be able to look back on it again and again until the problem is solved. Basically in a perfect word let a user be able to see a status of the problem along with a unique number for there reference.

If this does not make sense let me know!!

Cheers

Steve

Hi all,

I basically want to select information from an excel spreadsheet and place it somewhere else to make a summary page.

If possible if would be great to do this into word or an lotus notes email but anyway would be much help.

Thanks in advance

Hi Everyone,

I have a point and click macro driven system for my uni project. Im trying to save one of the worksheets call it 1, clear the sheet and then fill it in again and then save it again, with a new number i.e 2. Preferably sequential.

Thanks very much

Hi All,

Im a new user on the forum and I am also a new user of VBA.

I am interested in learning more and wanted to see if this lotus notes code could be modified to allow for you to:

1) Predefine who the email is sent to
2) Assign the active sheet to be the attachment.

Basically automating the process more??

If anyone can help that would be great.

I can send attachments of what im trying to do if that helps
:tumble: