Search:

Type: Posts; User: gjadcock; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    227

    Thanks Lewiy, works a treat :wink:

    Thanks Lewiy, works a treat :wink:
  2. Replies
    2
    Views
    227

    Command Buttons

    Hi, I'm a bit of a numpty when it comes to VBA, but have managed to write some codes that performs actions when a command button is clicked, part of which is to set the enabled flag to False to...
  3. Replies
    5
    Views
    984

    Andrew, Have sussed it using: ...

    Andrew, Have sussed it using:

    ActiveSheet.bldg_code_entry.Activate under Workbook_open

    Thanks for your help on the other questions
  4. Replies
    5
    Views
    984

    Excellent, works fine now Thanks. Just one...

    Excellent, works fine now Thanks.

    Just one more thing, on the sheet I have a textbox, is there anyway to have the text box selected (waiting for input, cursor flashing etc) the instant the user...
  5. Replies
    5
    Views
    984

    Thanks Andrew, One problem the EnableSelection...

    Thanks Andrew, One problem the EnableSelection property seems to be re-setting itself to NoRestriction when I re open the file, any ideas??

    Yes, I have un-protected the sheet, made the changes,...
  6. I had a similar problem dealing with the US and...

    I had a similar problem dealing with the US and came to the conclusion that the Regional Settings dictate how the dates are shown, however this does mean that if you enter a date in the UK the date...
  7. Replies
    3
    Views
    625

    Re: removing empty rows

    Can you not test to see if A1 is empty, if so hide the row, and move on to test a2
  8. Replies
    5
    Views
    516

    I am a little new to this stuff but, you can...

    I am a little new to this stuff but, you can create a macro that has the following lines:

    Range("C:C,F:F,I:I,L:L,O:O").Select
    Selection.ColumnWidth = 5

    This is OK if you know the...
  9. Replies
    5
    Views
    984

    Hide Menu and tool bars

    What VB code do I need to turn off menu bars and tool bars so the user just sees the top title bar when opening the file. Also is there any way to prevent the user selecting any cells on the front...
  10. Thread: Get user name

    by gjadcock
    Replies
    1
    Views
    448

    Get user name

    How do I get the NT Username and insert this into a table.

    I have tried using a shell command and "cmd.exe /c ECHO %USERNAME%" but I seem to get a nonsense number instead of the actual name in the...
  11. Replies
    6
    Views
    1,041

    Re: Disable Cell Selection

    Excelent, worked like a dream, except I replaced the

    Range("$A$1").Select

    with

    bldg_code_entry.Activate

    to keep the text box live
  12. Replies
    6
    Views
    1,041

    Re: Disable Cell Selection

    Is this option available under 2000?

    If I go to TOOLS > PROTECTION > PROTECT SHEET I get 3 tick boxes to select what is protected (Contents, objects, scenarios) and a pwd box??

    Am I looking in...
  13. Replies
    6
    Views
    1,041

    Re: Disable Cell Selection

    Thanks, but thats not really what Im looking for. I want to completley disable the cell selection i.e. if the user clicks out of the query text boxes into the background worksheet, no cells are...
  14. Replies
    6
    Views
    1,041

    Disable Cell Selection

    I have written an application to search and sort data, my first sheet is the query window, is there any way to prevent the user selecting the cells in this sheet.
  15. Replies
    4
    Views
    1,267

    Re: Save As - Very Confused

    fname.name gives me the file name and extension only without the path which is what I need. I managed to work out the save bit by seperating the statement onto two lines so it now reads:

    ...
  16. Replies
    4
    Views
    1,267

    Save As - Very Confused

    I am trying to write a save as button which requests a file name using the standard saveas dialogue, this then performs a series of copy and paste routines then saves the file.

    Private Sub...
  17. Replies
    4
    Views
    424

    Re: Text box and Enter Keys

    Andrew,

    Works great, thanks.

    As always, there is something else. If the text box search is invalid I have a message (vbExclamation) which tells me so, however if I now press enter to remove the...
  18. Replies
    4
    Views
    424

    Text box and Enter Keys

    I have been looking through the archives and cannot seem to get any of the example code working.

    I have a text box which the user completes and a button which takes the value in the text box and...
  19. Replies
    1
    Views
    572

    Guys, I have approx 15 txt files which I have...

    Guys,

    I have approx 15 txt files which I have written VB code to import into excel and format, text to columns etc and save as xls.

    I need some code that will merge the files together into one...
  20. Replies
    2
    Views
    472

    Mark, This is exactley what I mean, the...

    Mark,

    This is exactley what I mean, the problem I have is that the data is published to my clients as a report and I have to manually search for the change in floor number and then re-format to...
  21. Replies
    2
    Views
    594

    I have a spreadsheet of building data which has...

    I have a spreadsheet of building data which has hundreds of rows (one for each room in the entire building), how can I create a VB script to check column A, which contains floor number (0,1,2,3...),...
  22. Replies
    2
    Views
    472

    I have a spreadsheet of building data,how can I...

    I have a spreadsheet of building data,how can I create a VB script to check column A, which contains floor number (0,1,2,3...), and when the floor number changes insert two rows put a border around...
  23. Replies
    3
    Views
    690

    thanks aladin, this is exactley what I have,...

    thanks aladin, this is exactley what I have, however I need the range to be dynamic. If I add extra lines to the selection list I dont want to keep altering the range (more likely I'll forget, and...
  24. Replies
    4
    Views
    760

    Thanks, but I need to test the value in the cell...

    Thanks, but I need to test the value in the cell if its common, vert etc then I need to set Invalid, else set to Valid
  25. Not sure if this will work but try ...

    Not sure if this will work but try

    =indirect(a1)

    this will use the result of the formula in a1 as a value
Results 1 to 25 of 27
Page 1 of 2 1 2