I am getting error on this "cannot find object or library" :-
Any speedy way to resolve it !!! How do i place the calendar ??
All names have been modified ,take note.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook pag
Hi Paul J Irwin,
Solution given is based on then requirement...
Yes you can have search box in forms too
Check this attachment...
Cheers!!
On Sun, Feb 8, 2015 at 7:21 PM, Paul I wrote:
> Hi Vabs,
>
> This doesnt do the same thing as
> http://trumpexcel.com/2013/10/excel-drop-down-list-wi
Hi Vabs,
This doesnt do the same thing
as http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/
The beauty of the method in the above linked is that it does not matter if
the string you have started typing is part of the second, first, or any
word, it will find that stri
ul for me.
>>> Thanks a ton!
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>> -- Forwarded message --
>>> From: Abhishek Jain
>>> Date: Tue, May 27, 2014 at 4:13 PM
>>> Subject: Re: $$Excel-Macros$$ User Fo
really a very very helpful for me.
>> Thanks a ton!
>>
>> Regards
>> Pravin Gunjal.
>>
>> -- Forwarded message --
>> From: Abhishek Jain
>> Date: Tue, May 27, 2014 at 4:13 PM
>> Subject: Re: $$Excel-Macros$$ User Form for Data Entry wi
ate: Tue, May 27, 2014 at 4:13 PM
> Subject: Re: $$Excel-Macros$$ User Form for Data Entry with few Automations
> To: MS EXCEL AND VBA MACROS , Pravin
> Gunjal
>
>
> If it doesn't necessarily have to be an userform, you can try the
> attached.
>
> Let me know if you need any
Hello,
It would be helpful if you could attach the excel sheet also...
Regards,
Pavithra
On Mon, Apr 15, 2013 at 7:48 PM, Thomas Yantorno <
salestaxconsult...@gmail.com> wrote:
> Hello,
>
> I have code that looks to modify a cell when there is a value placed in a
> user form. My issue is that
Hello,
I have code that looks to modify a cell when there is a value placed in a
user form. My issue is that there are multiple text boxes in the user form
and I only want the user form to update the cell if there is a value, but
ignore a text box if there is no value. Currently, it will update
hi Ashish,
Pl provide the solution, if you can.
On Sunday, October 7, 2012 11:48:00 AM UTC+5:30, prabhat.sh...@gmail.com
wrote:
>
>
>
> Hi Ashish,
>
> The excel list is consists of account nos in text format in column A i.e.
> 05223300056, 05223300057, 05223300058 & so on rest w
Hi Ashish,
The excel list is consists of account nos in text format in column A i.e.
05223300056, 05223300057, 05223300058 & so on rest will be done
by query excel forms/input box.
Regards,
Prabhat Shrivastava
On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote:
> can
can you share the sample file
On Sun, Oct 7, 2012 at 11:03 AM, prabhat.shrivasta...@gmail.com <
prabhat.shrivasta...@gmail.com> wrote:
> This group help me a lot for ma assignment time to time, I m really happy
> to be the member of this group.
>
> here again, I've some query & require help from
This group help me a lot for ma assignment time to time, I m really happy
to be the member of this group.
here again, I've some query & require help from expert of this group. I
need to create a user input form.
I've a list of data in a particular excel spreadsheet, what I want is as
soon i en
Thanks Chilexcel
On Thu, May 24, 2012 at 10:23 PM, ChilExcel wrote:
> Good Job Noorain Ansari !!!
>
>
> Chilexcel
>
> 2012/5/24 NOORAIN ANSARI :
> > Dear Deba,
> >
> > Please see attached Userform, hope it will help you.
> >
> >
> > --
> > Thanks & regards,
> > Noorain Ansari
> > www.noorai
Good Job Noorain Ansari !!!
Chilexcel
2012/5/24 NOORAIN ANSARI :
> Dear Deba,
>
> Please see attached Userform, hope it will help you.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, May 22, 2012 at 6:01 PM, Deba Ranjan w
Hi Team,
I need your help in creating a user form.
Here is what I'm looking for.
I have some brands in Range("B1:B5") in Sheet1 and are in the order as below
Brand1
Brand2
Brand3
Brand4
Brand5
and some brands are present in sheet2 in the order different than sheet1 like
Brand5
B3
Brd2
Brand_4
gt;>>
>>> Thanks
>>> Prasad
>>> On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>>
>>>> What userform? Put this in the ThisWorkbook module
>>>>
>>>> Private Sub Workbook_Open()
>>>> nameofyouruserformhere.Show
&g
39 PM, dguillett1 wrote:
>>>
>>>> What userform? Put this in the ThisWorkbook module
>>>>
>>>> Private Sub Workbook_Open()
>>>> nameofyouruserformhere.Show
>>>> End Sub
>>>>
>>>> *From:* Suryaprasad
>
; Prasad
>> On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>
>>> What userform? Put this in the ThisWorkbook module
>>>
>>> Private Sub Workbook_Open()
>>> nameofyouruserformhere.Show
>>> End Sub
>>>
>>> *F
rom:* Suryaprasad
>> *Sent:* Tuesday, August 30, 2011 7:42 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ User form
>>
>> Hi All,
>>
>> Need a small help
ue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>
>> What userform? Put this in the ThisWorkbook module
>>
>> Private Sub Workbook_Open()
>> nameofyouruserformhere.Show
>> End Sub
>>
>> *From:* Suryaprasad
>> *Sent:* Tuesday, August 30, 2011
Sub
>
> *From:* Suryaprasad
> *Sent:* Tuesday, August 30, 2011 7:42 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ User form
>
> Hi All,
>
> Need a small help , i need to get a pop up of the user form when my excel
> is o
What userform? Put this in the ThisWorkbook module
Private Sub Workbook_Open()
nameofyouruserformhere.Show
End Sub
From: Suryaprasad
Sent: Tuesday, August 30, 2011 7:42 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ User form
Hi All,
Need a small help , i need to get a pop
Hi Prasad,
Look attached below...
If you want to create some VBA Coding in background of userforms..You have
to save the file has a .XLS or
XLSM because XLSX wont support Macro Language..
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad wrote:
> Hi All,
>
> Ne
Hi All,
Need a small help , i need to get a pop up of the user form when my excel
is opened, see the attachment
Thanks
Prasad.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
again you should use ratio buttion on this
Please find attached solution
Regards
Santosh Bahuguna
On Tue, Jun 28, 2011 at 11:53 PM, Rash wrote:
> Hi all,
>
> Need Help...
>
> I have a user form in which i have 6 check boxes. ok and cancel button.
>
> when ever I click 1st check box, rows 1 to
Dim ws As Worksheet
Const pass As String = "rash"
Dim ArChkBox(1 To 6) As Object
Private Sub UserForm_Activate()
Set ArChkBox(1) = CheckBox1
Set ArChkBox(2) = CheckBox2
Set ArChkBox(3) = CheckBox3
Set ArChkBox(4) = CheckBox4
Set ArChkBox(5) = CheckBox5
Set ArChkBox(6) = CheckBox6
Hi all,
Need Help...
I have a user form in which i have 6 check boxes. ok and cancel button.
when ever I click 1st check box, rows 1 to 10 should to be editable, rest
all rows should be non editable and hidden.
For check box 2, rows 11 to 20 editable, rest up and down area should be non
edita
rom my computer(s) for a few days.
>
> I'll try to take a look today.
> I thought I sent it, but don't see it, so I'll have to re-create it.
>
> Paul
>
>
> From: Manish
> To: MS EXCEL AND VBA MACROS
> Sent: Mon, Februar
February 7, 2011 10:34:59 AM
Subject: Re: $$Excel-Macros$$ User form value in current active row
Any help pls.
-
Manish
On Feb 7, 12:12 pm, Manish wrote:
> Dear Paul & EE,
>
> I want to write the value of userform in same PRA worksheet in column
> T:AA in same row.
>
>
Any help pls.
-
Manish
On Feb 7, 12:12 pm, Manish wrote:
> Dear Paul & EE,
>
> I want to write the value of userform in same PRA worksheet in column
> T:AA in same row.
>
> For example: if user enter the value is in PRA Sheet column M8,
> userform will write the value in cell T8:AA8, same as if
Dear Paul & EE,
I want to write the value of userform in same PRA worksheet in column
T:AA in same row.
For example: if user enter the value is in PRA Sheet column M8,
userform will write the value in cell T8:AA8, same as if user enter
the value in PRA Sheet column M11, I want to write the userfo
t;
> Do you have control over the protection? or is it owned by others?
>
> how do you want it to behave?
>
> can you send me what you have so far and let me look at it?
>
> Paul
>
>
> From: Manish
> To: MS EXCEL AND VBA MACROS
>
XCEL AND VBA MACROS
Sent: Mon, January 31, 2011 6:23:04 AM
Subject: Re: $$Excel-Macros$$ User form value in current active row
I tried the code suggested by you. It�s working�
Bt I am not comfortable when sheet it protected.
If possible, pls attach the sample file.
Thanks once again!!
What a
erform, use: UserFormName.Show
>
> Give that a try.
> If you need more help, let me know and I'll write it when my macro finishes.
> (It's loading 600,000 records into an Oracle database.. it takes a while)
>
> Paul
>
>
> Fro
into an Oracle database.. it takes a while)
Paul
From: Manish
To: MS EXCEL AND VBA MACROS
Sent: Tue, January 25, 2011 8:10:47 AM
Subject: Re: $$Excel-Macros$$ User form value in current active row
Thanks Paul.
My column is selectable.
If user select/edit in the ce
To: MS EXCEL AND VBA MACROS
> Sent: Tue, January 25, 2011 1:37:03 AM
> Subject: $$Excel-Macros$$ User form value in current active row
>
> Dear Excel Experts,
>
> Can you please suggest me the code for following task.
>
> My sheet is password protected and Column B is l
7;ll be able to make changes to other cells,
but to make changes to column B, you'll have to
know the password and unprotect the sheet.
Paul
From: Manish
To: MS EXCEL AND VBA MACROS
Sent: Tue, January 25, 2011 1:37:03 AM
Subject: $$Excel-Macros$$ User f
Dear Excel Experts,
Can you please suggest me the code for following task.
My sheet is password protected and Column B is locked. When user try
to enter the data in any cell of column B, I want to open one user
form.
I am comfortable with build the user form. In my user form I have six
TaxtBox, I
Hello,
I need some help in creating an user form or input screen in excel so
I can input two number manually...my code is as follows:
I need to create some type of input box for specifying range numbers
1) f Range(WS_RANGE).Value > 6465 And Range(WS_RANGE).Value < 6469
Then and
2) If Range(WS_RA
39 matches
Mail list logo
