vba excel form to read worksheet cell values

T

tjolley

New Member
Joined
Feb 24, 2004
Messages
4
Can we get a form in Excel(VBA) to read the cell values in a worksheet...I can get the form text boxes to read from one to the other and what not, but I was wondering if it was possible to read from the cells in the worksheet instead of from each other on the form.

thanks so much.

Tim Jolley
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
Hi - Welcome to the board

Try something like

Code: 
Userform1.TextBox1.Text = Sheets("Sheet1").Range("A1").Value
Userform1.Label1.Caption = Sheets("Sheet2").Range("B5").Value
 
Upvote 0
Can we get a VBA Excel form to read cell values from a worksheet....is this possible...I can get it to read from text box to text box and from form to form but not from the worksheet.

Thanks so much for your time.
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Solved
Display Lookup table from dropdown list in a form?
Replies
3
Views
264
myall_blues
myall_blues
T
  • Solved
Get second last row?
Replies
4
Views
140
TheWennerWoman
T
E
  • Solved
Update worksheet cell from user form entry
Replies
9
Views
214
EssKayKay
E
M
  • Solved
Utility Meter Reading Formulas
Replies
4
Views
538
mtbe
M
E
  • Solved
Run Subroutine located in Sheet1 from a command button in a form?
Replies
3
Views
218
NdNoviceHlp
NdNoviceHlp

Forum statistics

Threads
1,221,564
Messages
6,160,513
Members
451,655
Latest member
rugubara

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top