Assuming that your country column is column A, place the following
code into the VBA section of the form containing your three ComboBoxes
(referred to as cmbBoxCountry, cmbBoxState and cmbBoxProduct) and give
it a try:
Private Sub cmbBoxCountry_Change()
Call UpdateComboBox("B", cmbBoxState, c
Please explain why you don't save the worksheet resulting from your
calculations in the intrinsic Excel format (i.e. as an Excel
workbook).
On Nov 8, 12:20 pm, Hemant Hegde wrote:
> Hi
>
> After a lot of coding and lengthy calculations (takes up to 2 minutes) I get
> a sheet (actually a report)
Dear Paul and gurus,
I want to find the last row. Is this OK?
Private Sub Worksheet_Change(ByVal Target As Range)
Dim LastRow As Long
If WorksheetFunction.CountA(Cells) > 0 Then
'Search for any entry, by searching backwards by Rows.
LastRow = Cells.Find(What:="*", After:=[A1], _
dear gurus,
say i have a worksheet, but i want to limit the printing of this worksheet
to 10 times only. is it possible?
any vba idea. most probably this is a worksheet print event?
im new to macro. thanks for understanding.
dellosa
--~--~-~--~~~---~--~~
-
Dear Paul,
'This is the event
Private Sub Worksheet_Change(ByVal Target As Range)
' i want to test if the last row is with data is 10th row or greater.
is there a need for dim declaration? Basically a code to test if the user
is using the 10th row or more. I want to limit the data until row numb
good morning Paul & Paulo
I like both your name.. Well sorry for confusing you.. anyway. i think you
are right i need to put some vba in that worksheet where if the rows with
data is 10 or more. ( yes rows 1-9 has data)
I want to limit the inputs of the user to upto 10 rows only. the worksheet
Hi Excel-Experts !
I wish to build a Macro which does some routine work on UnixBoxes via
launching Telnet.
I can successfully launch Telnet Session using SHELL command but further if
I wish to type in using Macro I am not...
Please anyone can share an idea to make it work?
cheers
Kamal
--~--~--
Dear Sir/Madam
Pl see the file attached...
Regards
--
Jitender
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
Dear Sir,
Thanks for all type of solution
I need it in access database too . can it be possible ?
Thanks
Jitender
On Sun, Nov 8, 2009 at 10:59 PM, ashish koul wrote:
> chek this are u looking for this
>
> On Sat, Nov 7, 2009 at 9:14 PM, Jitender wrote:
>
>>
>> Dear Sir
>>
>> Pl.see the prob
Dear Sir
Thanks for solution
But i need its vice versa too from some purpose how to do that
Again thanks
Jitender
On Sun, Nov 8, 2009 at 10:59 PM, ashish koul wrote:
> chek this are u looking for this
>
> On Sat, Nov 7, 2009 at 9:14 PM, Jitender wrote:
>
>>
>> Dear Sir
>>
>> Pl.see the probl
Sub New_Name()
Dim tName
tName = Application.InputBox("Enter New Name")
Range("A1").Value = tName
End Sub
Note, I would be CAUTIOUS of using a "keyword" like "Name"
as a variable.
Excel uses it for SO many things. It could get confusing
Paul
From: T
I need to be able to insert text into a cell using the “inputbox”
function linked to a button. The macro below allows me to input the
text, but getting it to go somewhere eludes me. I realize that
"Copy.Name" doesn't work but how do i direct the entered text to a
cell? Suggestions appreciated.
T
Yeah,
Its possible.you can create pivot on basis on multiple range
consolidation.But data in multiple sheet should be in same format.
Go-To -Data>>Pivot table and chart >>Select-Multi consolidation
range>>Select sheet one by one.
On Mon, Nov 9, 2009 at 10:10 AM, Mahesh wrote:
> Hi All,
>
>
Good Morning Dellosa,
How many rows and columns do you have in your sheet?
Please, give us more information about your problem...
Best Regards
On 9 nov, 02:31, OSAVentures Calamba wrote:
> dear gurus,
>
> i need to close a workbook if last row with data =10, Any VBA suggestion
> please?
>
>
I may be a little slow... but why does it need to be a constant within
the "Type"?
If what you're saying is that MySviData.mDataType is always 1, then
why do you need to declare it?
sorry,
can't see a way...
Paul
On Nov 6, 1:46 pm, Hemant Hegde wrote:
> Is there a way to declare a constant s
First of all, let's deal with the overflow problem.
How are you declaring the variables?
What data type?
I mean, Double precision Real is -1.79769313486231E308 to
-4.94065645841247E-324
Long Integer is -2,147,483,648 to 2,147,483,647
that seems pretty big!!!
But, let's say you're still overrunni
What do you mean by "last row with data = 10"?
do you mean that row #10 has data?
or that the last row with data has a VALUE of 10 in a specific column?
will there be data in rows 1-9?
What columns will the data be in? look for ANY data in row 10?
What do you want to use to trigger the event?
Whe
What you're seeing is not a "module", it is a VB Project.
Since you don't see an open spreadsheet, the workbook is hidden.
It may be an add-in.
Based on the name, my guess is that it is a custom toolbar.
What version of Excel are you using?
someone here may be able to help you remove it..
if you
Dear Tony,
Earlier you wanted the sum of largest 3 labels which are greater than Zero
and your previous email also confirms the same, reproduced belowP-
**
*"I have to find the sum only of the first 3 A that are greater than zero"*
Now as you have changed the requirement and need sum of 14 values
First of all many thanks to Dilip and Deepak for the answers!!!
Sadly they don't solve my problem, what I exactly need is one formula
that sum the value only of the first 14th values, and ignore any
further value.
This is a sample of my worksheet:
A B C
Time
You are always welcome..!!
Thanks & Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Nov 9, 2009 at 12:36 AM, Deepak Rai wrote:
> Thanks Dilip for your kind response. It is really helpful.
>
>
21 matches
Mail list logo