Search:

Type: Posts; User: rsf5048

Search: Search took 0.02 seconds.

  1. Re: Check for Existance of data on Userform Page

    This is my current solution to the problem. It is pretty crude but does the job. It takes each combobox goes in as a combobox.value. It checks to see if its empty then displays whats empty and...
  2. Check for Existance of data on Userform Page

    Hey Guys,

    I am looking to find a way to check for the exsistance of data on a userform page. So inother words if the user forgets to enter a field on a selected page then. This will prompt the...
  3. Replies
    3
    Views
    1,457

    Re: Identifying ActiveShape Name

    Sheets("Sheet2").PasteSpecial(Format:="Picture (Enhanced Metafile)", Link:=False, DisplayAsIcon:=False)
    set newshp = Selection.ShapeRange
    newshp.left = range(r2).left
    newshp.top = range(r2).top...
  4. Replies
    3
    Views
    1,457

    Re: Identifying ActiveShape Name

    Thanks i will test it on my code and let you know how it works
  5. Replies
    11
    Views
    3,415

    Re: [RESOLVED] Copy Paste Sub help Needed

    Well I need to have my final data in some type of unlinked form such that the user will be unable to change the final product on the excel sheet. As well as it allows me to save the charts as...
  6. Replies
    11
    Views
    3,415

    Re: [RESOLVED] Copy Paste Sub help Needed

    I get this error when a run the code using select.

    Run-time Error '1004':
    PasteSpecial method of WorkSheet class failed.
  7. Replies
    3
    Views
    1,457

    [RESOLVED] Identifying ActiveShape Name

    So i am having a problem with my code. I need some way to identify a shape/picture right after it has been pasted to a sheet in a picture format. My current code should work but does not do what i...
  8. Replies
    11
    Views
    3,415

    Re: Copy Paste Sub help Needed

    Sub CopyPaste_Chart()
    Sheets("Email PDF").ChartObjects("FwdGSpdPDF").Activate
    Selection.Copy
    Sheets("Comparison").Activate
    Sheets("Comparison").PasteSpecial Format:="Picture...
  9. Replies
    11
    Views
    3,415

    Re: Copy Paste Sub help Needed

    Sorry I ment Userform.
  10. Replies
    11
    Views
    3,415

    Re: Copy Paste Sub help Needed

    I probably should have mentioned this before. It runs in marcos but won't run for my Powerform which is where i need it to run.
  11. Replies
    11
    Views
    3,415

    [RESOLVED] Copy Paste Sub help Needed

    I am having some problems with some code that is suposed to copy a chart from one sheet and paste it into another as an unlinked Picture. I am getting a runtime error that is

    Run-time Error...
  12. Re: Adding Items to Combobox multi combo boxes

    TypeSelect is a form level variable and it is assgined as a string currently.
  13. Replies
    4
    Views
    1,015

    [RESOLVED] Timing VB Code

    I was wondering if someone knows if there is some type of VB Timer that will time how long your code runs for. I ask this because i am looking for a way to optimize the speed of my code.
  14. [RESOLVED] Adding Items to Combobox multi combo boxes

    So let me explain a little bit about what my code needs to do. I have multi-tabs on a userform that all use the same the same data for several combobox. Data for the comboboxes are pulled from excel....
Results 1 to 14 of 14



Click Here to Expand Forum to Full Width