User Form Problem

M

Marc W

Hi,
i would greatly appreciate any help with the following problem.

I have a user Form consisting of a List box containg the day of the Week and
Four Text Boxes labeled with material codes.

On my worksheet I have the days listed down the Left hand colum and the
Material codes across the top of Columns B-E .

I am finding it difficult to write a code which will save the text I enter
in the text boxes to the respective cells in the worksheet against the day I
select in the List Box.


Thanks in advance

marc
 
R

Rick Rothstein

Can you give us some details on your set up please. What is the name of your
ListBox? What is the name of your TextBoxes? Which TextBoxes go with which
columns (B-E)? What is the day of the Week... the day of week number(1-7) or
the day of week name (Sun-Sat)? How is the "day of week" entered in your
worksheet... as a real date formatted to your "day" value, a text string, a
number between 1 and 7, something else? I presume your material codes are in
Row 1 and that your day of week values are in Column A, correct? That would
mean your upper leftmost piece of data starts in cell B2, right?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User form Text Box & Combo Box. 5
Open Specific Worksheet Using Button Form Control in Excel 0
Linking Check Box in User Form to Workbook 8
user form start field 3
Filling a Form 4
user form parameters 1
Control Text Box Data Transfer 2
Selecting from Worksheet to fill combo boxes on User Form 1

Top