Consulting

Results 1 to 12 of 12

Thread: Test

  1. #1
    VBAX Regular pike's Avatar
    Joined
    Dec 2007
    Location
    Alstonville, Australia
    Posts
    94
    Location

    Test

    v A B C D E F G H
    1 order product qty 1 2 3 10 30
    2 1001 orange 3 A AA AAA AAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
    3 1002 berry red 1
    4 1002 berry red 1
    5 1002 berry purple 1
    6 1003 apple red 1
    7 1003 apple green 2
    8 1004 berry red 1
    9 1004 apple red 1

  2. #2
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,964
    Location
    AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGH!
    I always expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  3. #3
    VBAX Regular pike's Avatar
    Joined
    Dec 2007
    Location
    Alstonville, Australia
    Posts
    94
    Location
    v A B C D E F G H
    1 order product qty 1 2 3 10 30
    2 1001 orange 3 A AA AAA AAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
    3 1002 berry red 1
    4 1002 berry red 1
    5 1002 berry purple 1
    6 1003 apple red 1
    7 1003 apple green 2
    8 1004 berry red 1

  4. #4
    Quote Originally Posted by pike View Post
    v A B C D E F G H
    1 order product qty 1 2 3 10 30
    2 1001 orange 3 A AA AAA AAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
    3 1002 berry red 1
    4 1002 berry red 1
    5 1002 berry purple 1
    6 1003 apple red 1
    7 1003 apple green 2
    8 1004 berry red 1
    9 1004 apple red 1
    Hello,

    Please need help how can I post sheet example as shown in this post

    Thank you

    Regards,
    Moti

  5. #5
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,964
    Location
    It is a screenshot posted as an image.

    If you only need a simple table with no colors and no borders, you can copy the Range in Excel and paste it directly into your post here.

    If you "Go Advanced," You can upload attachments, (after a minimum of posts here,) add borders to the Table and add or remove Rows and Columns.

    If you want to paste code into your post, please click the # Icon in the Editor menu to insert CODE tags and paste the code between the Tags.
    I always expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  6. #6
    Quote Originally Posted by SamT View Post
    It is a screenshot posted as an image.

    If you only need a simple table with no colors and no borders, you can copy the Range in Excel and paste it directly into your post here.

    If you "Go Advanced," You can upload attachments, (after a minimum of posts here,) add borders to the Table and add or remove Rows and Columns.

    If you want to paste code into your post, please click the # Icon in the Editor menu to insert CODE tags and paste the code between the Tags.
    Thank you SamT, for your kind help

    I understand all except you said the #post3 "It is a screenshot posted as an image." How can it is possible If I highlight the image and can paste in to excel sheet directly and able to read it. Or please tell me how the screen shot is taken.

    Thank you

    Regards,
    Moti

  7. #7
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,964
    Location
    On the top row of keyboards is a key that says PrntScr. This key copies the screen to the clipboard as a bmp image.

    Open an image editor like MS Paint and paste into the image editor.

    Use the image editor to Crop the image, then save it as a *png or *jpg file on your desktop.

    When you are on VBAExpress.com, the menu Icon between the blue globe and the hash mark icon will let you upload an image from your computer into your post.
    I always expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  8. #8
    Quote Originally Posted by SamT View Post
    On the top row of keyboards is a key that says PrntScr. This key copies the screen to the clipboard as a bmp image.

    Open an image editor like MS Paint and paste into the image editor.

    Use the image editor to Crop the image, then save it as a *png or *jpg file on your desktop.

    When you are on VBAExpress.com, the menu Icon between the blue globe and the hash mark icon will let you upload an image from your computer into your post.
    Testing

    Name:  ABC.jpg
Views: 107
Size:  24.7 KB

  9. #9
    Thank you SamT, yes I get success to post screen shot as per your instruction after posting it I tried to copy back to excel it is not possible instead #post1 and #post 3 text yes please will you take a look

    Regards,
    Moti

  10. #10
    Moderator VBAX Wizard SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    6,964
    Location
    No you can not paste a picture into excel.

    My bad. That is not an image in posts #1 & #3

    The tables in those posts were hand coded by the OP. He used the A/A Icon to view and edit the Source of his post.

    Here is how he did it
    [_TABLE="class: thin_grid"] (Remove underscore in "[_Table")
    [TR]
    [TD]v[/TD]
    [TD="align: center"]A[/TD]
    [TD="align: center"]B[/TD]
    [TD="align: center"]C[/TD]
    [TD="width: 11, bgcolor: #ECF0F0, align: center"]D[/TD]
    [TD="width: 21, bgcolor: #ECF0F0, align: center"]E[/TD]
    [TD="width: 29, bgcolor: #ECF0F0, align: center"]F[/TD]
    [TD="width: 98, bgcolor: #ECF0F0, align: center"]G[/TD]
    [TD="width: 290, bgcolor: #ECF0F0, align: center"]H[/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]1[/TD]
    [TD="bgcolor: #FFFFFF"]order[/TD]
    [TD="bgcolor: #FFFFFF"]product[/TD]
    [TD="bgcolor: #FFFFFF"]qty[/TD]
    [TD="bgcolor: #FFFFFF"]1[/TD]
    [TD="bgcolor: #FFFFFF"]2[/TD]
    [TD="bgcolor: #FFFFFF"]3[/TD]
    [TD="bgcolor: #FFFFFF"]10[/TD]
    [TD="bgcolor: #FFFFFF"]30[/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]2[/TD]
    [TD="bgcolor: #FFFFFF"]1001[/TD]
    [TD="bgcolor: #FFFFFF"]orange[/TD]
    [TD="bgcolor: #FFFFFF"]3[/TD]
    [TD="bgcolor: #FFFFFF"]A[/TD]
    [TD="bgcolor: #FFFFFF"]AA[/TD]
    [TD="bgcolor: #FFFFFF"]AAA[/TD]
    [TD="bgcolor: #FFFFFF"]AAAAAAAAAA[/TD]
    [TD="bgcolor: #FFFFFF"]AAAAAAAAAAAAAAAAAAAAAAAAAAAAAA[/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]3[/TD]
    [TD="bgcolor: #FFFFFF"]1002[/TD]
    [TD="bgcolor: #FF0000"]berry red[/TD]
    [TD="bgcolor: #FFFFFF"]1[/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]4[/TD]
    [TD="bgcolor: #FFFFFF"]1002[/TD]
    [TD="bgcolor: #FFFF00"]berry red[/TD]
    [TD="bgcolor: #FFFFFF"]1[/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]5[/TD]
    [TD="bgcolor: #FFFF00"]1002[/TD]
    [TD="bgcolor: #FFFFFF"]berry purple[/TD]
    [TD="bgcolor: #FFFFFF"]1[/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]6[/TD]
    [TD="bgcolor: #FFFF00"]1003[/TD]
    [TD="bgcolor: #FFFFFF"]apple red[/TD]
    [TD="bgcolor: #FFFFFF"]1[/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]7[/TD]
    [TD="bgcolor: #FFFFFF"]1003[/TD]
    [TD="bgcolor: #2F75B5"]apple green[/TD]
    [TD="bgcolor: #FFFFFF"]2[/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]8[/TD]
    [TD="bgcolor: #FFFFFF"]1004[/TD]
    [TD="bgcolor: #FFFFFF"]berry red[/TD]
    [TD="bgcolor: #FFFFFF"]1[/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [/TR]
    [TR]
    [TD="bgcolor: #ECF0F0, align: center"]9[/TD]
    [TD="bgcolor: #FFFFFF"]1004[/TD]
    [TD="bgcolor: #FFFFFF"]apple red[/TD]
    [TD="bgcolor: #FFFFFF"]1[/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [TD="bgcolor: #FFFFFF"][/TD]
    [/TR]
    [/TABLE]
    I always expect the student to do their homework and find all the errrors I leeve in.

    Please take the time to read the Forum FAQ

  11. #11
    Quote Originally Posted by SamT View Post
    No you can not paste a picture into excel.

    My bad. That is not an image in posts #1 & #3

    The tables in those posts were hand coded by the OP. He used the A/A Icon to view and edit the Source of his post.

    Here is how he did it
    SamT, I thought that would be created by some Add inns to post easily but it is a bit difficult

    Thank you for your time and help

    Regards,
    Moti

  12. #12

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •