Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default filling text boxes from a combo box

I have a form with 6 text boxes and a combobox. I have
been able to add data from the text boxes to the combo
box.

What I would like to do know is let the user select a row
from the combobox and populate the 6 text boxes with the
data (where they can edit the data)

AND (2) once the data has been changed I want to update
the combobox with the new data.

Will I have to delete the combobox row and add a new row
or can I keep the same row and just update the
information.

Any help getting started would be appreciated. Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default filling text boxes from a combo box

You can keep the same row and update the information. I gave you code on
filling the textboxes.

Just loop through your list and find the row (recall that the first row is
zero based).

then

..list(rw,columnNumber) = Textbox1.Text

as an example.


--
Regards,
Tom Ogilvy

"JT" wrote in message
...
I have a form with 6 text boxes and a combobox. I have
been able to add data from the text boxes to the combo
box.

What I would like to do know is let the user select a row
from the combobox and populate the 6 text boxes with the
data (where they can edit the data)

AND (2) once the data has been changed I want to update
the combobox with the new data.

Will I have to delete the combobox row and add a new row
or can I keep the same row and just update the
information.

Any help getting started would be appreciated. Thank you.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Getting Combo boxes to change options based on other Combo boxes. Ancient Wolf New Users to Excel 1 March 27th 09 06:29 PM
Make text cells and combo boxes required? mlroy@savvis Excel Discussion (Misc queries) 2 July 24th 06 08:19 PM
Selecting subsets using combo boxes or list boxes CLamar Excel Discussion (Misc queries) 0 June 1st 06 07:43 PM
filling combo boxes from single outer source alekm Excel Discussion (Misc queries) 1 February 17th 06 01:49 PM
Filling form text boxes from cells. Incredibly simple I know, but I'm new. :-( Paul Crabb Excel Programming 0 November 18th 04 01:49 AM


All times are GMT +1. The time now is 04:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"