Try re-installing OS..
Cheers!!
On Wed, Jan 7, 2015 at 12:01 PM, Pavan Chowdary
wrote:
> Hi All,
>
> This is Pavan. I have a file which contains forms combo boxes. After
> installing recent windows updates, i am unable to see combo boxes
> properties and getting visual basics errors.
>
> I hear
Hi All,
This is Pavan. I have a file which contains forms combo boxes. After
installing recent windows updates, i am unable to see combo boxes
properties and getting visual basics errors.
I heard there are bugs in windows updates which is why we are facing this
issue. can you guys tell me any
Hi Experts
I have added one dropdown in custom menu using xml. can i add their item
value using macros, on workbook_activate method?
Divaker
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use c
Hi,
Shall I get the codes or basics to study on these codes so that I can use
the controls in excel and make them working in a simple way.
Please do send me any material with the basics of codes, so that I can
understand the use and try from my end to apply it.
On Thu, Jun 14, 2012 at 3:35 PM, Sm
Thanks Noorain. Its working.
Shall I get the codes or basics to study on these codes so that I can use
the controls in excel and make them working in a simple way.
Please do send me any material with the basics of codes, so that I can
understand the use and try from my end to apply it.
I don't hav
Hi Smitha,
Check this one..
On Thu, Jun 14, 2012 at 3:09 PM, Smitha S R wrote:
> Hi,
>
> Its not working.
>
>
> On Thu, Jun 14, 2012 at 3:01 PM, NOORAIN ANSARI
> wrote:
>
>> Hi Smitha,
>>
>> Please see atached sheet.-
>>
>>
>>
>> -
>> Thanks & regards,
>> Noorain Ansari
>> www.nooraina
Hi,
Its not working.
On Thu, Jun 14, 2012 at 3:01 PM, NOORAIN ANSARI wrote:
> Hi Smitha,
>
> Please see atached sheet.-
>
>
>
> -
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Thu, Jun 14, 2012 at 2:13 PM, Smitha S R wrote:
>
>> Is it pos
Hi Smitha,
Please see atached sheet.-
-
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jun 14, 2012 at 2:13 PM, Smitha S R wrote:
> Is it possible to include the items in one sheet to a combo box in other
> sheet.
>
>
>
> For example, if in sh
Is it possible to include the items in one sheet to a combo box in other
sheet.
For example, if in sheet 1 there is names and in the second sheet there is
combo box with the heading names. Shall I get the names of other sheet in
the combo box as and when I go on adding the names in the first She
Hi Smitha,
MS Excel: Creating a combo box in Excel 2003/XP/2000/97
--
Question: I'm trying to create pull down boxes in Excel 2003/XP/2000/97
with selections to highlight and fill in the cell. How do I do that?
Answer: To create a combo box in Excel, the first thing
Hi Smitha,
Use data validation from Excel.
MAngesH
On Tue, May 29, 2012 at 2:01 PM, Smitha S R wrote:
> How we can place a combo box in excel work sheet?
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Pleas
How we can place a combo box in excel work sheet?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not b
Dear Noorain,
Thnak for your help
On Feb 16, 9:12 pm, NOORAIN ANSARI wrote:
> Dear Prajakt,
>
> Please see attached sheet with explanation.
>
> On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande wrote:
>
>
>
>
>
> > Dear,
>
> > Good job, can you tell me how you made this.
>
> > Regards,
> > Prajakt
many many thank you N Ansary for you quick reply
regards,
Sanjib
On Fri, Feb 17, 2012 at 2:02 PM, NOORAIN ANSARI wrote:
> Dear Sanjib,
>
> Please find attachment in 2003 Version.
>
> On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>> Dear N ANSARI,
Dear Sanjib,
Please find attachment in 2003 Version.
On Fri, Feb 17, 2012 at 1:16 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
> Dear N ANSARI,
>
> WOULD YOU PLEASE CREATE THE ATTACH FILE IN 2003 FORMAT. .
>
> THANKING YOU IN ADVANCE.
>
> SANJIB
>
>
>
> On Thu, Feb 16, 2012 at
Dear Prajakt,
Please see attached sheet with explanation.
On Thu, Feb 16, 2012 at 5:04 PM, Prajakt Pande wrote:
> Dear,
>
> Good job, can you tell me how you made this.
>
> Regards,
> Prajakt Pande
>
>
> On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed wrote:
>
>> Hi,
>> Please chek it
>>
>> On Thu
Dear,
Good job, can you tell me how you made this.
Regards,
Prajakt Pande
On Thu, Feb 16, 2012 at 3:27 PM, Shaik Waheed wrote:
> Hi,
> Please chek it
>
> On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Experts,
>>
>> Please see the attac
Process
1
Drag Combobox From Developer-Insert-Form 2 Select Combobox and goto
Developer-Properties and Select Areal List and select Cell Link Cell 3 create
formula =ADDRESS(2,8+H1)&":"&ADDRESS(100,8+H1) 4 Create Offset Function
=OFFSET($H$1,0,$H$1,COUNTA(INDIRECT($B$12)),1),Copy it and Paste i
Once again thank you Sir for quick reply. But would you please show me the
process.
Regards,
Sanjib
On Thu, Feb 16, 2012 at 4:57 PM, Shaik Waheed wrote:
> Hi,
> Please chek it
>
> On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
> chatterjee.kolk...@gmail.com> wrote:
>
>>
>> Dear Expe
Dear Sanjib.
See attached sheet.
On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Experts,
>
> Please see the attachment. I like store AREA1, AREA2 AND AREA3 in a combo
> box or in Text Box.
>
> Base on the value store in the combo Box or list b
Hi,
Please chek it
On Thu, Feb 16, 2012 at 4:39 PM, Sanjib Chatterjee <
chatterjee.kolk...@gmail.com> wrote:
>
> Dear Experts,
>
> Please see the attachment. I like store AREA1, AREA2 AND AREA3 in a combo
> box or in Text Box.
>
> Base on the value store in the combo Box or list box I like the n
Thanks Noorain and Ashish
On Mon, Nov 28, 2011 at 10:58 AM, NOORAIN ANSARI
wrote:
> Dear Yahya,
>
> Please check attached sheet with Userform.
>
>
> On Mon, Nov 28, 2011 at 12:47 PM, Yahya Muhammad wrote:
>
>> Thanks Ashish. It does the trick. Just one more question. Instead of
>> providing the
Dear Yahya,
Please check attached sheet with Userform.
On Mon, Nov 28, 2011 at 12:47 PM, Yahya Muhammad wrote:
> Thanks Ashish. It does the trick. Just one more question. Instead of
> providing the combo box in a worksheet, If I want to keep the combo box in
> a user form (which should open wi
Thanks Ashish. It does the trick. Just one more question. Instead of
providing the combo box in a worksheet, If I want to keep the combo box in
a user form (which should open with the file) , how the code will look
like?.
On Mon, Nov 28, 2011 at 9:48 AM, ashish koul wrote:
> use in
>
> Private
Dear Yahya,
please see updated Sheet..
On Mon, Nov 28, 2011 at 11:09 AM, Yahya Muhammad wrote:
>
> Thanks Noorain. But the issue is the combo box is not dynamically updated.
> For eg: if I insert one more sheet in the sample sheet, say Sheet9, it will
> not appear in the combo box unless I clos
use in
Private Sub Worksheet_Activate()
Sheet1.ComboBox1.Clear
Dim sh As Worksheet
For Each sh In Worksheets
Sheet1.ComboBox1.AddItem (sh.Name)
Next
End Sub
On Mon, Nov 28, 2011 at 11:09 AM, Yahya Muhammad wrote:
>
> Thanks Noorain. But the issue is the combo box is not dynamically updated.
> F
Thanks Noorain. But the issue is the combo box is not dynamically updated.
For eg: if I insert one more sheet in the sample sheet, say Sheet9, it will
not appear in the combo box unless I close and reopen the file. Any
solutions?
On Mon, Nov 28, 2011 at 8:18 AM, NOORAIN ANSARI wrote:
> Dear Yah
Dear Yahya,
Please try below code and see attached sheet..
Private Sub ComboBox1_Change()
Sheets(ComboBox1.Value).Activate
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim sh As Worksheet
For Each sh In Worksheets
Sheet1.ComboBox1.AddItem (sh.Name)
Next
End Sub
--
Tha
Hi experts
I have a work book which has a lot of worksheets. I have a master sheet in
the same workbook in which there is a combo box. I need this combo box to
have the names of all worksheets in the workbook. Any sheets added/deleted
in the workbook should also be auto updated in the combo box.
Hi everyone,
I am having trouble creating a simple table in Access with a combo box
and retrieving the information into two text boxes. Here it is what I
have done:
1. imported a Excel file into Access
2. Created a table with the Excel Spreadsheet
3. Created a query with three columns that I nee
Hi,
I've managed to get a combo box on a spreadsheet. Now I want to copy
that combo box down in column A for a hundred and fifty or more rows
and the linked cell to each combo box needs to be the adjacent cell to
each combo box in column B. I'll end up using what's in column B
later on for a VLO
31 matches
Mail list logo
