Search:
Type: Posts; User: rsf5048
Search:
Search took 0.02 seconds.
-
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...
-
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...
-
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...
-
Thanks i will test it on my code and let you know how it works
-
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...
-
I get this error when a run the code using select.
Run-time Error '1004':
PasteSpecial method of WorkSheet class failed.
-
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...
-
Sub CopyPaste_Chart()
Sheets("Email PDF").ChartObjects("FwdGSpdPDF").Activate
Selection.Copy
Sheets("Comparison").Activate
Sheets("Comparison").PasteSpecial Format:="Picture...
-
-
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.
-
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...
-
TypeSelect is a form level variable and it is assgined as a string currently.
-
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.
-
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....
|
Click Here to Expand Forum to Full Width
|