Mr. Wallace,
Thanks for your query. Well, don't bother your English is fine. I'm
taking your problem and hope my answer is useful to you. Please adjust
it according to your needs, I tried and it was working as per my
perception.
Sub abc()
For i = 1 To 45
..Width = _
..Width
no idea ? Or may i learn english before posting my questions ? lol
José
On 15 nov, 01:13, Alfred WALLACE wrote:
> hello to all !
>
> I'm trying to make a shape in an userform,
> and, to make longuer longuer this shape
> like a progress bar for a time duration.
>
> for exemple, my duration is 45
attach the form, let me check.
Kishan Reddy, K
On Jul 28, 10:16 pm, b wrote:
> I have an Excel workbook w/ a VBA menu to pops up a userform to write
> values back to a worksheet in the workbook. Sometimes, the userform
> locks Excel and it has to be abended. I suspect its due to users have
> oth
I can't really help you with part 1,but
**do you now about auto_size, take a look at it
**if you want resize the height of rows 10 to 26 just select them (by:
selcting and dragging down the row numbers, OR select you first and
Shift select the last row) and when you resize by dragging row border
th
most welcome
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Mon, Sep 14, 2009 at 9:40 AM, suresh k wrote:
> Hi Harmeet,
>
> thank you. Now its working.
> I was using useform activate function. Thats y it was not working.
>
> Anyways thank you so much for your help.
>
>
>
> On
Hi Harmeet,
thank you. Now its working.
I was using useform activate function. Thats y it was not working.
Anyways thank you so much for your help.
On Mon, Sep 14, 2009 at 9:17 AM, Harmeet Singh wrote:
> *Created a file for ur ease**see attached file..*
>
> Thanks & Regards,
>
> Harmee
Hi Harmeet,
Thanks for your reply.
In this case, after running the userform. I need to click on that. And the
time will count from that time.
So If I dont click anywhere, it will not close.
Any suggestions..
Regards,
Suresh
On Sat, Sep 12, 2009 at 2:42 AM, Harmeet Singh wrote:
> Below code ma
Below code may help u
*Sub um()*
*If Application.Wait(Now + TimeValue("0:00:10")) Then*
*MsgBox "Time expired" ' or write "Unload Me" here*
*End If*
*End Sub*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Fri, Sep 11, 2009 at 10:23 AM, suresh k wrote:
> Hi,
>
Great Just what i need many thanks for your help
Jack
On Jun 16, 9:35 pm, Phillip Swanepoel wrote:
> Hey...
>
> Sorry for late reply.
>
> Firstly i gota declare that i am still learning my self and there is
> probably "cleaner" and beter solution.
>
> This is what i came up with so long...
>
>
I would fill in a sheet for name & number so there are no mistakes
when choosing
a drop down
Cheers
On Jun 16, 10:30 am, Phillip Swanepoel wrote:
> What is the criteria on the name? does the user at some time enter his/her
> name and number of does the develeper do this on the sheet? the deve
Thanks thats great but Name & tel Would to come from a sheet1 from
Cols a and b (like a data validation field ) Also questions from
sheet 2 cols a & b - I need to collate the answers on sheet 3 and
only the user can view the quiz user form & I all
Cheers
On Jun 16, 9:15 am, Phillip Swanepoel
What is the criteria on the name? does the user at some time enter his/her
name and number of does the develeper do this on the sheet? the develeper
select his/her name from a list on the userform?
This email has been forwarded using a mobile phone with a internet/wap
application. Go to www.op
Name & tel Would come from a sheet1 Cols a and b Also questions from
sheet 2 cols a & b - I need to collate the answers on sheet 3 and
only the user can view the quiz user form
Thanks for you reply
On Jun 16, 8:09 am, Phillip Swanepoel wrote:
> what kinda ten Q's u need?
>
> where does the na
what kinda ten Q's u need?
where does the names and tel numbers come from? you want to fill it in r
must it come from the sheet?
Do you want to view the sheet? print the sheet?
etc
please reply with more spesific specs. would be nice if you can attach a
sample or pix of what you vision
know. But
there are also unknown unknowns. There are things we don't know we don't know."
From: Ashish Jain <26may.1...@gmail.com>
To: MS EXCEL AND VBA MACROS
Sent: Sunday, 7 June, 2009 9:31:48 AM
Subject: $$Excel-Macros$$ Re: UserFo
know. But
there are also unknown unknowns. There are things we don't know we don't know."
From: Ashish Jain <26may.1...@gmail.com>
To: MS EXCEL AND VBA MACROS
Sent: Sunday, 7 June, 2009 9:31:48 AM
Subject: $$Excel-Macros$$ Re: UserFo
know. But
there are also unknown unknowns. There are things we don't know we don't know."
From: Ashish Jain <26may.1...@gmail.com>
To: MS EXCEL AND VBA MACROS
Sent: Sunday, 7 June, 2009 9:31:48 AM
Subject: $$Excel-Macros$$ Re: UserFo
Hi Alokeshwar,
This is absolutely normal.
1. When you try to fetch the values from userform1, it is initialized
and new value of Test set upon. To avoid this you can use activate
event of userform1. Difference between activate and initialize is of
Foreground visibility active state and Backgroun
hi,
I have a better way If you have a series of controls that you would like to
format
the same way...suggest you name the textbox "txtbxname_1" ("_1") becomes our
unique identifyer)
for each.
if right(object.name,4) = "_1" then
next
next
On Sun, Apr 5, 2009 at 8:46 PM, Ashish Ja
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
On Mar 20, 8:08 am, Damascus wrote:
> Hi everyone.
>
> I am creating a macro that incorporates a userform. It is functional
> and in use, but there is a small thing that is still a problem. For
> some background, there are 2 sets of 2 textboxes for entering data,
> along with an 'enter' command
On 4 Lut, 13:46, Paul Schreiner wrote:
> Actually, I thought your English was fine.
> In fact, I didn't even notice any problem until you said
> "I know it isn't QUITE good"... although it works,
> you probably should've used: "I know it isn't very good"..
> But you got the message across nicely
Actually, I thought your English was fine.
In fact, I didn't even notice any problem until you said
"I know it isn't QUITE good"... although it works,
you probably should've used: "I know it isn't very good"..
But you got the message across nicely.
Now to the question.
You're clicking LABELS.?
HI phillip,
This code would be useful to complete up your task.
textbox20.Value = Sheets("Sheet17").Range("B9").Value & Sheets
("Sheet17").Cells(Sheets("Sheet17").Range("K65535").End(xlUp).Row,
"K").Value
textbox21.Value = Sheets("Sheet17").Range("A9").Value & Sheets
("Sheet17").Cells(Sheets("S
25 matches
Mail list logo
