Jump to content

MrBass

Members
  • Posts

    4657
  • Joined

  • Last visited

Everything posted by MrBass

  1. your method i thinki, i right clicked the worksheet and input the code that way. I've formated the cells now to include the time but it always comes up as 00:00 That's Pud's method and:
  2. 250GB? Pfft, 1TB is where it's at today bay_bee!
  3. Which method are you using - Pud's super method or my simple one? Either way, you'll need to make sure column is formatted correctly, right-click, Format Cells..., select the Custom category and in the Type: field, enter DD/MM/YYYY HH:MM:SS or whatever format you like.
  4. cool so where do i put it? what do i do with it? I havent got Excel to hand but I believe that if you go into Tools>Macros>Visual Basic Editor then you'll get two panes, the left hand side has a sort of navigation tree, click on the worksheet you're wanting to do it on and cthe right hand pane will go clear. Paste it in there to attach it to that Workbook. i must be doing something wrong as it seems to have no effect on anything! my lack of VB knowledge isnt helping me out much like! At the bottom of your workbook, you should have different tabs for each sheet. If you haven't renamed them and still got your defaults, it'll be Sheet1, Sheet2, Sheet3. Right-click on Sheet1 and, from the pop-up menu, select 'View Code' - This will launch the VBA editor. By default, your current workbook should be the top window in the right pane - if it's a brand new workbook, the window title will be 'Book1 - Sheet1 (Code)' You'll have two dropdown menus at the top, the left one will be defaulted to '(General)' and the right one '(Declarations)' Click the down arrow for the left dropdown menu and select 'Worksheet' The right dropdown should default to 'SelectionChange', click the down arrow in the right dropdown and select 'Change' The will already give you the 'Private Sub... ...End Sub' lines from Pud's code so you'll just need to paste the other lines inbetween. Once done, go back to your workbook and test! Edit, if you also want the timestamp recorded, then instead of 'Int(Now)', just use 'Now'
  5. If you're okay with the date/time stamp updating whenever you update the values in column B then this'll do the job =IF(B1="","",NOW()) You'll also need for format column A to be the date/time format you require.
  6. Also be warned that if you have the 2nd Gen iPod touch, some of the in-car adapters won't charge your iPod unless you buy a special dongle.
  7. Well spoken Kenneth - nothing warms my heart quite so much as extreme Liverpool hatred +1
  8. Bit of a poor turnout on the Christmas avatars this year folks. Note: This post was only made so Christmas Achmed could come out to play.
  9. Would have been better if he caught the shoe and whipped it back at the bloke rendering him unconscious!
  10. MrBass

    X Factor

    the other finalists were shite and should have gone out weeks ago. Alexandra and Laura were the best 2, followed by Diana Vickers and Rachel the ex hooker or whatever she was. All girls. The best bloke singer went out about 5 weeks ago, can't remember his name. Aye I watched it. Early rounds make you laugh and later on there are some good singers and Cheryl and Danni are well worth watching. Austin
  11. MrBass

    X Factor

    Is the right answer! I hate Nadine's spindly legs. +1 Oh and... Kimberly Cheryl Nicola Nadine Sarah With the exception of Kim, they've all lost far too much weight, and Sarah would have been higher up the list if she hadn't lopped all her hair off.
  12. ow ow ow ow Ouch, that made my bum wink. Yikes! It's not so much the initial break, it's when you see he's about to try and stand on it!
  13. MrBass

    Help: phbb forums

    What about if you add in a width="50" on the following line: <td class="row1" align="center" valign="middle" height="50"><img src="templates/RedSilver_C/images/folder_big.gif" width="" height="" alt="Pas de nouveaux messages" title="Pas de nouveaux messages" /></td> You'll obviously have vars in place of the literal strings, been a while since I've played with phpBB so I'll just make some up! <td class="row1" align="center" valign="middle" height="50"><img src="{IMG_UNREAD}" width="" height="" alt="{L_ALT}" title="{L_TITLE}" /></td> Anyway, what does: <td class="row1" align="center" valign="middle" width="50" height="50"><img src="{IMG_UNREAD}" width="" height="" alt="{L_ALT}" title="{L_TITLE}" /></td> Give you?
  14. Aye, Texas Hold em is canny good, also quite like EA's Soduku
  15. MrBass

    Help: phbb forums

    Tried deleting your cookies?
  16. Get yourself Google Chrome and use the incognito tab for all things um... saucy.
  17. ...and GPS, Bluetooth and 2MP camera.
  18. MrBass

    Spelling

    If you use Google Chrome to browse then, yes. "Interesting" note, Google isn't a recognised word in the Google spell checker.
  19. MrBass

    Dexter

    Is this download from the states viewing, or has it snuck on TV without me noticing?
  20. Were they the best odds you can get? Surely if he's so confident he should be forking over the £50 if they don't and you forking over £25 if they do?!
  21. MrBass

    Tom

    Merry Birthday[/brock] Have a good one fella!
  22. It's amazing how quickly they can turn. My ex (of 5 years) fucked off with some guy 15 years her senior, let me know it was over via email, left me with all her debt, hired a solicitor to try and get half my house then, two years later when I finally got everything sorted, tried adding me as a friend on Facebook! As Brockles quite rightly says, snakes with tits.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.