ComboBox in Spreadsheet -

Hi All,
I need to include a combobox in the spreadsheet.

Any Help?

Regards,
Mohit.

ComboBox in Spreadsheet -
Hi All, I need to include a combobox in the spreadsheet. Any Help? Regards, Mohit.

simple transfer value -
If i have an excel spreadsheet with a combobox. ComboBox has different names. If i have a certain name highlighted. how do i move that name into a textbox on a userform?

"INDIRECT" References in Userform ComboBox--Excel 2003 -
Does anyone know a way to use the "=INDIRECT" function in a userform combobox the same way it would be used in a regular combobox (i.e. one that is just in a spreadsheet)? In other words, I have two comboboxes with lists of choices. In the first box, the user will select a re

Icon next to value in comobobox -
Hi all, I have a comobox which is populated by a range of cells in an array on a OWC spreadsheet control embedded into my vb6 form. When the 'Save' button is selected i want a Tick icon to be displayed next to the Name in the combobox. Is it possible to add an icon next to a v

Assign a range of cells to a combobox in a VB project -
How would I assign an Excel range on a spreadsheet to a combobox, so anything in the range shows as entry in the dropdown ? I know in VBA I can use the .Rowsource property, but in VB I don't appear to have this option. Any ideas anyone ? Thanks.

Refresh ComboBox after changing ListFill Range -
It sounds a basic question but I'm struggling to sort it (I only started learning this last year) ! I have a ComboBox on an Excel spreadsheet and three OptionButtons. Selecting an OptionButton changes the ListFillRange of the ComboBox. But the text in the ComboBox does not change un

[Excel] "Clicking" on a ComboBox from a macro in another spreadsheet -
I have a spreadsheet with some combo boxes that runs code when they're clicked. I want users to be able to fill out drop down boxes in a different spreadsheet, then run a macro that fills out the combo box and runs the code. Is there a way to do that? I also tried having the macro u

Unhiding an Excel Spreadsheet -
I am updating an Excel Spreadsheet with VB6. After all action is taken I save and close the Spreadsheet with the following code: xl2.Application.Workbooks(2).Worksheets("schedule start").Activate xl2.Application.WindowState = xlMaximized 'xlMinimized xl2.Applic

[resolved] function returns combobox -
Hi, On a form I have a combobox that I want to be filled with data. I fill a different combobox with a dataset and the combobox datasource. I do this in a seperate class-file. Now I want to return this combobox to the combobox on the form. However this results in no data in the com

OLE technology -
Does anyone know how to use OLE technology to embed a spreadsheet such as MS Excel into a window. I basically, have a spreadsheet and want to use OLE to embed the spreadsheet to my VB application to allow the user to edit the spreadsheet. If anyone knows how to implement this I woul

Writing or deleting tekst in a spreadsheet in vb -
I've made a program and in this program i intergrated a spreadsheet. Searching in this spreadsheet works and also updating. Now i want that when i put info in a textbar en push a button , that the info will be writin in the spreadsheet and also be saved but also make it possible to c

Display spreadsheet on vb forms.. -
Display spreadsheet how do i display an excel spreadsheet on a picture box or is there other alternatives(which i believe there is but dunno how) that can display a spreadsheet on a control of a vb form that can also scroll up/down /left/right ? thank!

Autolength combobox -
i have a combobox. the length of the combobox is fixed. i dont wnt to adjust the length as i want my form look neat so i want all combobox are in the same length. but the problem arise when the data that loaded in the combobox is longer than the combobox length (like in the attachmen

SendMessage to spreadsheet control -
Hi, I am a relative newbie to visual basic. I have a spreadsheet control window that subclasses another window, are there any window messages to send to this spreadsheet ( SendMessage(hwnd,????,0,"abc" ) so i can write values to the different cells in the spreadsheet (note:

RE: Using chartspace by getting values from Spreadsheet -
Hi All, I am very new to vb and have just started using it, I am using a comport to receive data from a GPS unit and then I am putting the data into a spreadsheet from that spreadsheet. I am trying to create a xy scatter using chartspace from the data in the spreadsheet, but not

#N/A displayed -
I have one spreadsheet called A that has cells that reference cells in another spreadsheet called B with formulas as simple as ='[B.xls]Costs'!$B54 The problem is that if I close spreadsheet B, some of the cells in spreadsheet A show #N/A sign. As far as I know, spreadsheet B shoul

Spreadsheet XP Web Component Questions -
Hi, I am using the Spreadsheet - XP Web Components object in my VB application and have a few questions about it. - Is it possible to save the data the user enters into the spreadsheet so that it is there when they open the program in future? - When spreadsheet data is export

VBA / Excel Question -
Is it possible to have spreadsheet 'A' execute a macro from spreadsheet 'B' WITHOUT having spreadsheet 'B' open?

Populating ComboBox/DropDown in visual basic 6.0 -
Hey, im kinda stuck atm...im completing my project for A level at college, and i would like to know how to populate a ComboBox/Dropdown list in visual basic. I have the data i want (a list of counrties) in an Excel Spreadsheet, but i have no idea what to do to get it displayed in the c

Accessing No. Rows In Excel Spreadsheet from VB -
I am writing a data import utility which takes data from an excel spreadsheet and loads them into a database. When I count the no records in the spreadsheet it returns 60000+. This seems to be the number of rows in the spreadsheet, but only 6500 have data in them. Is there a way of

ComboBox stuff -
Hi, I am programming in access '97 and now I want to use a comboBox to do the following: If I type a new value into my ComboBox that isn't in the list I want to Add it to the table where I created the list However using the NotInList option I can add the new entry but somehow

VB 6.0 - How to programatically add a comment to spreadsheet -
Good people, Please can someone show me how I can add a permanent comment to the end (footer) of m spreadsheet. I want this comment to be visible when the spreadsheet is printed. I know how to add the comment on the spreadsheet that is visible only when you hover the cursor on it.

How to print spreadsheet -
Hi I hv created the application where i show the selected excel file contents in SPreadsheet on form. now i want to print that spreadsheet or spreadsheet contents. can anyone help me!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!11 Thanks for reply P

Question about DataGridView ComboBox column -
I have a couple questions about a DGV combobox column: 1) Is there a way to type in your own text into a DGV combobox like you can with a standard combobox? 2) Is there an event to tell when an item from a DGV combobox has been selected? Thanks...

OWC Spreadsheet Control -
Hi I am unable to freeze the size of the spreadsheet component in Excel. I am using the OWC Spreadsheet control to display some data. Whenever I open the Excel application the size of the OWC Spreadsheet is increasing(both width and Height). Please help.

VBA/Access ComboBox question.... -
I have a combobox on an access form, but when a user types key into the combobox, the text changes?! I just want them to be able to press like 'r' and it go to the R's in the combobox, not actually type 'r' into the combobox. Thanks, Justin Fox

Populating An Excel Spreadsheet From An ASP Page -
I have a desktop application that, based on a query to an Oracle database, populates an Excel Spreadsheet. All of this works fine, is deployed, and has been in use for several months. Now, I've been tasked with transforming this application into a Web page that will be run off of

Strange excel occurrence. -
Hi Everyone, I currently have an vb program that is pulling information from an Access database and then writing that information to an excel spreadsheet. The excel spreadsheet is then being saved and closed. One problem I keep running into that I am not sure how to fix is the fac

Combobox and API -
Ok, bet no one has this! Heh. I need to know how to make a Combobox function like a Microsoft Access 97/2000 Combobox. I know how to do the DataBinding and all that stuff, I just can't get it to Display more than 1 Column. Can anyone help me? Is there a way to SubClass into th

Transposing excel spreadsheet to a recordset -
I have a spreadsheet with 59 columns I want transpose into a recordset in VB. How do I do this. some of the fields in the spreadsheet have carriage returns and are 255 characters long.

Extracting url from excel spreadsheet -
Hi All, I am creating an automation script and have need some assistance please. Is it possible to extract a url from an excel spreadsheet and have it opened in the brower using VB6. (I will the do some basic rendering checks) then automatically move to the next url in the spre

Load a spreadsheet from another spreadsheet -
Hi All, Does anyone know the command to load an Excel spreadsheet from a macro contained within another Excel spreadsheet please? From workbook1, I am wanting to open workbook2, make some amendments based on the info in workbook1 and close workbook2. The amending seems simple,

Combobox problem (super urgent) -
I have a combobox populated with data from the database. I cant see some of the data when i select the combobox dropdown list. Anyone got any idea?? Is there a limit on how many items the combobox can display at one time? i tried typing the data in the editable region of the comb

[word] saving combobox data -
I have a userform that has a combobox in it. The combobox starts empty, then when a user types in a new string, that string is added to the combobox, up to 5 entries. I want the last 5 entries that were in the combox when I quit, to stay in the combobox when I open the document. Is

Hiding Spreadsheet -
When my program opens it opens a spreadsheet to get values. However if I open another spreadsheet while my program is running the new spreadsheet opens as well as displaying the spreadsheet for my program. My question is how do I hide my spreadsheet so even if another spreadhseet is

A puzzle -
I've attached a file that dumps values to an excel spreadsheet, the problem is I don't want a new spreadsheet created. I want the numbers to go into a new worksheet within the existing spreadsheet. I can use a macro to use these values with the other ones already in sheets 1,2,3 A

Combobox like the old Forms 2.0 combobox -
Hello everyone. I have a combobox that I bind data too. The users here want to be able to type in 2 or 3 characters and have the right vendor name come up in the combobox. With the default combobox that comes with vb .net 2003, everytime they press a letter on their keyboard, the co

protecting the spreadsheet causes xlConn fail -
Hi. I need to protect a spreadsheet and protecting the spreadsheet causes the .open of xlConn to fail. I need to check the protection status of the spreadsheet in vb and if protection is enabled, disable it, passing it the sheets unprotect password. Should be relatively simple us

Bringing textbox information to an excel spreadsheet -
I made a form and put a "Microsoft Office Spreadsheet 10.0" object in a form2 and have a form1 with many textboxes and then these text boxes will go into the spreadsheet So it starts out with just form1. It has lets say 3 text boxes and a command button. The text boxes wil

change to vb code when spreadsheet name gets changed -
Hi, i have a spreadsheet which automates other spreadsheets. This spreadsheet gets updated about once every 2 weeks and then gets saved with a different filename. what i would like to no is if it is possible that when the spreadsheet changes name for it to change the visual basic