Hi,
I'm not sure if this would work with forms, but when I put multiple text boxes
on a worksheet, I can change them all with the following code:
ActiveSheet.Shapes.Range(Array("Text Box 1", "Text Box 2", "Text Box
3")).Select
Selection.ShapeRange.Height = 84.75
Selection.ShapeR
Hi Vincent
It seems more like sharing information - and we dnt find any other way
to do this at runtime. If you've plz share with us.
Regards
Ashish Jain
On Apr 2, 6:09 pm, Yu wrote:
> Hi Dear all,
>
> I have this puzzle for a long time. I often program UserForm and
> always format control
Hi Phani Kumar,
This macro has a limitation. All sheets in the active workbook must
have same number of headers and same name. Try with some sample sheet
with this kind of data. Even if a single sheet is different from
others than this won't work.
Regards
Ashish Jain
On Apr 3, 11:40 pm, Kumar
Hi vitovla,
Use Exit keyword to break a process. You can use it to come out of
Subroutine or a Loop.
Its possible combinations are:
Exit Do
Exit For
Exit Sub
Regards
Ashish Jain
On Apr 4, 9:12 pm, vitovla wrote:
> Hello,
>
> I'm developing an application to download the data from yahoo finan
