Posts by yegarboy

Re: Picture from comments to user form

Upload a sample for us to see please

Re: Display Cell Until All Cells In Range Are Full

This should get you started. Place it in the Worksheet Activate Object and edit the range and display cell to your needs

Private Sub Worksheet_Activate()
If Range("A1:D11").Cells.Text = "" Then ' Edit Range here
Range("F1") = "Empty" 
Else     'Edit Display Cell Its F1 Currently
Range("F1") = "Full"
End If
End Sub

anytime you add data and change the sheet its updated HTH

Re: USD $10 For Command Button Sheet Timmer To Return To Home Page

Payment Sent! Thanks so much for your help

Re: USD $10 For Command Button Sheet Timmer To Return To Home Page

Resend my inbox was full

Re: USD $10 For Command Button Sheet Timmer To Return To Home Page

Nevermind Andrew i got it sorted your awesome. Send me a PM with payment info.

Re: USD $10 For Command Button Sheet Timmer To Return To Home Page

I think we have a winner! a few quick questions though. Can i change the return sheet to"Home" and if i created a duplicate userform of the "view only" and removed the timmer code would it apply to only "Home" sheet users i messed up and forgot to mention that i only wanted employees to have the timer not admin lol.

Re: USD $10 For Command Button Sheet Timmer To Return To Home Page

Testing Now

Re: Macro required Copy, Rename new worksheet with Combobox, Delete Rows +

Dim SheetName1, SheetName2 As String
SheetName1 = Range("J7").Value
SheetName2 = ActiveSheet.Name
Sheets.Add After:=Sheets(Sheets.Count)
ActiveSheet.Name = SheetName1
Sheets("Temp").Visible = True 'Edit template sheet
Sheets("Temp").Select
'will copy everything
Cells.Select
Selection.Copy
Sheets(SheetName1).Select
ActiveSheet.Paste
'goes back to where you started
Sheets(SheetName2).Select

Re: USD $10 For Command Button Sheet Timmer To Return To Home Page

Ok

I have a "View Only" command button that i need code added to. I would like to add a timmer to the button that returns the user to the home page after say 30 seconds. I dont want to apply it the whole book as i will be changing sheets often, just the sheet i select from the "View Only" button. Witch could be 1 of 150-200 sheets. I dont need 200 sheets coded just the button to apply a timmer 1 time for any sheet i choose. Shouldnt be to hard for you guys Use the admin account at log in. and the password is admin also.forum.ozgrid.com/index.php?attachment/35019/ Please let me know if further detail is needed

Re: Timer to display worksheet for only 30 seconds

Thanks for that Reafidy but still not quite right. Let me explain a tad better. When my workbook opens a user logs in. There are many users but only 2 types. "Employee's" and "Managers". If an employee logs in they are brought to a task sheet for data entry. They can not see the sheets they have entered data to. I have installed a "View Only" command button on there task sheet that loads all the relavant sheets with submited data for them to view. but because i dont want to add a return button to every sheet in the book is why i want to allow them x amount of time to view a sheet before returning them to there task sheet. My book is hundreds of sheets. Thanks for all your help

Re: Check if Both Values are Positive or Negative

Right

Re: Extract data from other sheets using drop down to select sheet name

Ok i understand

Re: Extract data from other sheets using drop down to select sheet name

Run me through what you would like to happen from start to finish

Re: Timmer to display worksheet for only 30 seconds

Thanks for your help. Cheers

Re: Extract data from other sheets using drop down to select sheet name

What exactly is the summary sheet supposed to do? I have populated the box with the car titles. but what else specificly needs to happen.

Re: Extract data from other sheets using drop down to select sheet name

forum.ozgrid.com/index.php?attachment/35009/

Here is what i mean

Re: Combo box: extracting data from other sheets

Instead of moving all the data to a summary sheet would it work if the summary sheet took you to the data?

Re: Timmer to display worksheet for only 30 seconds

I may have misguided you. Im sorry. I would like the userform to hide and then let the user have free range of the page. Then when time is up return to the home page.

Re: Timmer to display worksheet for only 30 seconds

Dim ws As Worksheets


 
 Dim sheetname As String


 
 sheetname = UserForm5.ListBox1.Value


 
 Sheets(sheetname).Select


 
 


 
Application.Wait (Now + TimeValue("00:00:10"))


 
Sheets("Home2").Activate


 
 


 
 


 
 


 
 End