Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thanks Andrew Yes I agree that the setup is...

    Thanks Andrew

    Yes I agree that the setup is not the ideal, but this is what I inherited.

    I have one of two options:

    1) Make each row in each column of different width, and I don't even know...
  2. justifying text in a merged cell in a table

    Hi Loungers

    I am writing a newsletter and I want to have a table of content.

    This table of content is going to be on the first page of the newsletter, where we have a table of 2 columns by 2...
  3. Replies
    0
    Views
    367

    Web Query to get all result pages

    Hi Loungers

    Is there a way to run a web query that can bring all resulting pages?

    For example you go to a web site and run a query for events happening between two dates. The results come into...
  4. Replies
    4
    Views
    542

    I need some design help

    Hi All

    Can anyone tell me how can I get the following done:

    I am building what I call a Dispatcher's Application. So here goes:

    I have a User form with a bunch of controls. The dispatcher...
  5. Replies
    7
    Views
    1,822

    Hi SteveNot really. I have less than 400. Unless...

    Hi SteveNot really. I have less than 400. Unless 400 is considered lots.What I see is a value being entered into a validated cell then the validation happens and the error message comes up and I...
  6. Replies
    7
    Views
    1,822

    Thank you Maud and SteveBut using data validation...

    Thank you Maud and SteveBut using data validation seems to produce a delay in processing where the cell value has not yet updated and the validation kicks in and produced an error.I will try and...
  7. Replies
    7
    Views
    1,822

    Limiting user input

    Hello AllI need to limit the User input to be only the next number higher than what is available.So in column BO I have a CountA formula to add up how many cells it the row are not empty. I can add...
  8. Replies
    8
    Views
    1,972

    Thanks Kweaver This did the trick. I was...

    Thanks Kweaver

    This did the trick. I was trying to use a range of exclusions but an If/And will work just fine.

    Thanks again

    Wassim
  9. Replies
    8
    Views
    1,972

    I am sorry Kweaver I hope that I have made my...

    I am sorry Kweaver

    I hope that I have made my question clearer by using this workbook as an example.

    Please let me know if it is still not clear.

    Sorry I had attached the wrong file but now...
  10. Replies
    8
    Views
    1,972

    Thanks RetiredGeekIn a nut shell which is what I...

    Thanks RetiredGeekIn a nut shell which is what I was supposed to do in the first place:I want to find duplicates in a column but not all duplicates.I want to find if I have 13 duplicated but I don't...
  11. Replies
    8
    Views
    1,972

    Check for certain duplicates but not all

    HelloI know that the CountIf has a range and criteria parameters but it does not seem to let me use them.For example I want to find duplicates in the range of 2 to 50 but exclude any letters.I have a...
  12. Replies
    2
    Views
    924

    Hi zeddyOK I am sorry this post does not contain...

    Hi zeddyOK I am sorry this post does not contain an answer for you but:1) Have you tried stepping into the macro code line by line and see whet line fails or what is happening that you disgruntled as...
  13. Replies
    5
    Views
    1,186

    Hi AllPardon me but why was a solution made of...

    Hi AllPardon me but why was a solution made of linking the worksheet cells in all these workbooks passed?I thought of this as I was reading the post.Any limitations on linking?Wassim
  14. Replies
    2
    Views
    570

    Some design ideas please

    Hello LoungersI have a project to complete and I would love to bounce some ideas and get some feedback.The application is a schedule app. and I will have the days of the week in row 1 and the names...
  15. Replies
    1
    Views
    363

    Sending a message in the body of an email

    Hello AllIs there a way I can add a standard text message in the body of an email?When I looked at With Eorkbook.SendMail all I got was recipients; SUBJECT; ReturnReceiptI do have MS Outlook...
  16. VBA code to capture dropdown entries on a web page

    Hi Loungers

    I have a target web site that has two dropdowns. I need to harvest the list items in the dropdowns, that is to copy the contents of the dropdowns into a range.

    I tried a web query...
  17. Replies
    1
    Views
    672

    Data validation technquied in Excel 3003,

    Hello LoungersI need to figure out how to do the following:In column A I have a list of buildings. The entries come from s list and the cell had data validation on it.What I want to do is that in...
  18. Replies
    1
    Views
    1,261

    2 ways to increment a numeic UpDown

    Hello Loungers

    OK am I crazy or what, no this is not my question my question is...

    Is there an easy way to have multiple ways to have a numeric UpDown increment by 1 and 10?

    Say if you click...
  19. Detect if the user has moved horizontally on a worksheet

    Hi All,

    I am writing an application where I need to filter a list anytime the user picks an item from the list.

    But I need to reestablish the original list if the user goes to a new column.
    ...
  20. Replies
    1
    Views
    1,225

    Need to align the output to the decimal point

    Hello All,

    I am writing a console application in VB 2008, and I need to align the output to the right so that the decimal point are in the same spot on each line.

    Something like:
    123.45
    ...
  21. Replies
    10
    Views
    2,002

    Detecting an Autofilter on a worksheet.

    Hi Lounger

    Is there a way to detect if a worksheet is filtered?

    If that is a possibility, how can I unfilter it, via VBA?

    Thanks

    Wassim
  22. PPT Quiz making --- Sorry in advance is this question was posted

    Hello Loungers

    I am very sorry if this question was answered before, I searched but did not come up with anything.

    I am thinking of making a PowerPoint presentation quiz for our department. The...
  23. Replies
    3
    Views
    4,354

    Thanks You Jefferson Yes this is bizarre. I...

    Thanks You Jefferson
    Yes this is bizarre. I tried MainUserForm.MultiPage1.Visible = True and it did not work. I guess from the example, we can see that the pages collection is base 0 where the...
  24. Replies
    3
    Views
    4,354

    Which page of a multipage control to display?

    Hi Loungers

    I am getting an error message about not being able to set focus on a control on a user form.

    The error message states: ďCanít move focus to the control because it is invisible,...
  25. Replies
    4
    Views
    1,393

    Hi Pjkarl You know I tried this technique and...

    Hi Pjkarl

    You know I tried this technique and I am not sure if the results are accurate. You see MS-Outlook changes the date time stamp simply by starting Outlook. So I need to wait a while, an...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4