#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Userforms

Hi

I am very new to this and I would like to find out how I can link any object in a userform (Textbox, combobox etc) to a cell in a worksheet so that when the form has been filled in it shows the info in a worksheet...

Can anyone help?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Userforms

look at the control source property of the control in the properties window.

sheet1!A1

in the control soucre property would case a value in the control to appear
in cell A1 of Sheet1

--
Regards,
Tom Ogilvy

Paul Clark wrote in message
...
Hi,

I am very new to this and I would like to find out how I can link any

object in a userform (Textbox, combobox etc) to a cell in a worksheet so
that when the form has been filled in it shows the info in a worksheet....

Can anyone help?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Userforms

Thanks Tom
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
Help with Userforms Panagiotis Marantos Excel Discussion (Misc queries) 2 July 25th 06 04:26 PM
I need some help with userforms T.c.Goosen1977 Excel Discussion (Misc queries) 0 June 30th 06 09:27 AM
userforms again... Jo[_4_] Excel Programming 3 September 21st 03 12:31 AM
userforms Jo[_4_] Excel Programming 2 September 17th 03 10:35 PM
Userforms Gary[_8_] Excel Programming 1 August 18th 03 03:26 PM


All times are GMT +1. The time now is 01:48 PM.

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"